office 2013 created excel file lost column data when opening in office 2016
I Am trying to open excel file which is created in office version 2013, And my office version is office 2016 whenever i open these file i lost all data of a column please help.]
[1]: https://i.stack.imgur.com/0Pzv8.png [Original Excel]
[2]: https://i.stack.imgur.com/ARAiO.png [After opening]
microsoft-excel microsoft-word microsoft-outlook microsoft-office office365
|
show 1 more comment
I Am trying to open excel file which is created in office version 2013, And my office version is office 2016 whenever i open these file i lost all data of a column please help.]
[1]: https://i.stack.imgur.com/0Pzv8.png [Original Excel]
[2]: https://i.stack.imgur.com/ARAiO.png [After opening]
microsoft-excel microsoft-word microsoft-outlook microsoft-office office365
Maybe the data was lost when you embedded the file into Word, so no way to restore it. Have you tried removing the file and embedding again?
– Máté Juhász
Feb 25 at 8:45
Your Screen Shots are unable to illustrate the real situation better share file on Cloud or Drop Box!!
– Rajesh S
Feb 25 at 8:47
Rajesh- Scenario is that one of our clients is who send an excel file through email, and whenever I try to open it, I lost all data of the column, And when I open the same file in office version 2013 then its working fine. My Office version 2016.
– Balraj Singh
Feb 25 at 9:41
Is there a formula in the column in question?
– Ted D.
Feb 25 at 20:25
No there is no formula in the column
– Balraj Singh
Feb 26 at 7:48
|
show 1 more comment
I Am trying to open excel file which is created in office version 2013, And my office version is office 2016 whenever i open these file i lost all data of a column please help.]
[1]: https://i.stack.imgur.com/0Pzv8.png [Original Excel]
[2]: https://i.stack.imgur.com/ARAiO.png [After opening]
microsoft-excel microsoft-word microsoft-outlook microsoft-office office365
I Am trying to open excel file which is created in office version 2013, And my office version is office 2016 whenever i open these file i lost all data of a column please help.]
[1]: https://i.stack.imgur.com/0Pzv8.png [Original Excel]
[2]: https://i.stack.imgur.com/ARAiO.png [After opening]
microsoft-excel microsoft-word microsoft-outlook microsoft-office office365
microsoft-excel microsoft-word microsoft-outlook microsoft-office office365
asked Feb 25 at 8:36
Balraj SinghBalraj Singh
162
162
Maybe the data was lost when you embedded the file into Word, so no way to restore it. Have you tried removing the file and embedding again?
– Máté Juhász
Feb 25 at 8:45
Your Screen Shots are unable to illustrate the real situation better share file on Cloud or Drop Box!!
– Rajesh S
Feb 25 at 8:47
Rajesh- Scenario is that one of our clients is who send an excel file through email, and whenever I try to open it, I lost all data of the column, And when I open the same file in office version 2013 then its working fine. My Office version 2016.
– Balraj Singh
Feb 25 at 9:41
Is there a formula in the column in question?
– Ted D.
Feb 25 at 20:25
No there is no formula in the column
– Balraj Singh
Feb 26 at 7:48
|
show 1 more comment
Maybe the data was lost when you embedded the file into Word, so no way to restore it. Have you tried removing the file and embedding again?
– Máté Juhász
Feb 25 at 8:45
Your Screen Shots are unable to illustrate the real situation better share file on Cloud or Drop Box!!
– Rajesh S
Feb 25 at 8:47
Rajesh- Scenario is that one of our clients is who send an excel file through email, and whenever I try to open it, I lost all data of the column, And when I open the same file in office version 2013 then its working fine. My Office version 2016.
– Balraj Singh
Feb 25 at 9:41
Is there a formula in the column in question?
– Ted D.
Feb 25 at 20:25
No there is no formula in the column
– Balraj Singh
Feb 26 at 7:48
Maybe the data was lost when you embedded the file into Word, so no way to restore it. Have you tried removing the file and embedding again?
– Máté Juhász
Feb 25 at 8:45
Maybe the data was lost when you embedded the file into Word, so no way to restore it. Have you tried removing the file and embedding again?
– Máté Juhász
Feb 25 at 8:45
Your Screen Shots are unable to illustrate the real situation better share file on Cloud or Drop Box!!
– Rajesh S
Feb 25 at 8:47
Your Screen Shots are unable to illustrate the real situation better share file on Cloud or Drop Box!!
– Rajesh S
Feb 25 at 8:47
Rajesh- Scenario is that one of our clients is who send an excel file through email, and whenever I try to open it, I lost all data of the column, And when I open the same file in office version 2013 then its working fine. My Office version 2016.
– Balraj Singh
Feb 25 at 9:41
Rajesh- Scenario is that one of our clients is who send an excel file through email, and whenever I try to open it, I lost all data of the column, And when I open the same file in office version 2013 then its working fine. My Office version 2016.
– Balraj Singh
Feb 25 at 9:41
Is there a formula in the column in question?
– Ted D.
Feb 25 at 20:25
Is there a formula in the column in question?
– Ted D.
Feb 25 at 20:25
No there is no formula in the column
– Balraj Singh
Feb 26 at 7:48
No there is no formula in the column
– Balraj Singh
Feb 26 at 7:48
|
show 1 more comment
1 Answer
1
active
oldest
votes
A few things I found you can try:
- Check the cell formatting. [Edit]
- Hide, unhide the column.
- Select the column and toggle the text color to white, then back to automatic.
Copy the sheet to a new workbook:
- Right-Click the sheet tab with the missing column
- Select
Move or Copy...
to open theMove or Copy
dialogue - Use the
To book:
pick list to select(new book)
- Check the
Create a copy
selection box. - Click
OK
- Save the new workbook that opens.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1409167%2foffice-2013-created-excel-file-lost-column-data-when-opening-in-office-2016%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
A few things I found you can try:
- Check the cell formatting. [Edit]
- Hide, unhide the column.
- Select the column and toggle the text color to white, then back to automatic.
Copy the sheet to a new workbook:
- Right-Click the sheet tab with the missing column
- Select
Move or Copy...
to open theMove or Copy
dialogue - Use the
To book:
pick list to select(new book)
- Check the
Create a copy
selection box. - Click
OK
- Save the new workbook that opens.
add a comment |
A few things I found you can try:
- Check the cell formatting. [Edit]
- Hide, unhide the column.
- Select the column and toggle the text color to white, then back to automatic.
Copy the sheet to a new workbook:
- Right-Click the sheet tab with the missing column
- Select
Move or Copy...
to open theMove or Copy
dialogue - Use the
To book:
pick list to select(new book)
- Check the
Create a copy
selection box. - Click
OK
- Save the new workbook that opens.
add a comment |
A few things I found you can try:
- Check the cell formatting. [Edit]
- Hide, unhide the column.
- Select the column and toggle the text color to white, then back to automatic.
Copy the sheet to a new workbook:
- Right-Click the sheet tab with the missing column
- Select
Move or Copy...
to open theMove or Copy
dialogue - Use the
To book:
pick list to select(new book)
- Check the
Create a copy
selection box. - Click
OK
- Save the new workbook that opens.
A few things I found you can try:
- Check the cell formatting. [Edit]
- Hide, unhide the column.
- Select the column and toggle the text color to white, then back to automatic.
Copy the sheet to a new workbook:
- Right-Click the sheet tab with the missing column
- Select
Move or Copy...
to open theMove or Copy
dialogue - Use the
To book:
pick list to select(new book)
- Check the
Create a copy
selection box. - Click
OK
- Save the new workbook that opens.
edited Feb 28 at 16:43
answered Feb 25 at 21:00
Ted D.Ted D.
75028
75028
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1409167%2foffice-2013-created-excel-file-lost-column-data-when-opening-in-office-2016%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Maybe the data was lost when you embedded the file into Word, so no way to restore it. Have you tried removing the file and embedding again?
– Máté Juhász
Feb 25 at 8:45
Your Screen Shots are unable to illustrate the real situation better share file on Cloud or Drop Box!!
– Rajesh S
Feb 25 at 8:47
Rajesh- Scenario is that one of our clients is who send an excel file through email, and whenever I try to open it, I lost all data of the column, And when I open the same file in office version 2013 then its working fine. My Office version 2016.
– Balraj Singh
Feb 25 at 9:41
Is there a formula in the column in question?
– Ted D.
Feb 25 at 20:25
No there is no formula in the column
– Balraj Singh
Feb 26 at 7:48