Pivot disappear after saving Excel file

Question

Pivot disappear after saving Excel file

Linh Vu 6

Hello,

I have an Excel file with Pivot table. I can save it but when I open again, all pivot table become normal data (attached file).
Please help me on this. What do i need to do to fix this?
Thank in advance.

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-02-09T08:50:53.72+00:00

Hi @Linh Vu ,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Di 0 Reputation points

2023-06-15T17:15:05.7166667+00:00

I am having the same issue..... Its not every time i open the workbook. Its been fine for weeks and is always saved as .xlsx (excel workbook). But i came in today after being out a day and when i opened it EVERY one of my pivots was just plain data and screwed up. some of my charts were gone. What the heck happened????

2 answers

Your answer

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-02-09T08:50:53.72+00:00

Hi @Linh Vu ,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Di 0 Reputation points

2023-06-15T17:15:05.7166667+00:00

I am having the same issue..... Its not every time i open the workbook. Its been fine for weeks and is always saved as .xlsx (excel workbook). But i came in today after being out a day and when i opened it EVERY one of my pivots was just plain data and screwed up. some of my charts were gone. What the heck happened????

Answer 1

Emi Zhang-MSFT 30,046 Microsoft External Staff

Hi @Linh Vu ,
What kind of file format did you use to save the Workbook?
I suggest you make sure the file format is .xlsx:

Please let us know if you would like further assistance, I'm glad to help you.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Sherri W 0 Reputation points

2023-08-08T20:43:20.8333333+00:00

I was confused as to why I would save my pivot tables and when I return to the file the pivot table and the raw data would be gone. I did a search and came across this post to save it as an .xlxs and that worked. Thank you

Answer 2

Hi,

Here are some reasons and methods you can try to fix this issue-

Check if the range of the data source for the pivot tables is set correctly. If the range is not properly defined, Excel may not recognize the data as a pivot table when you reopen the file. To set the data source range, select the pivot table, go to the "PivotTable Analyze" or "Options" tab, click on "Change Data Source," and ensure the correct range is selected.
It's possible that the workbook itself is corrupted, leading to the loss of the pivot table structure. You can try repairing your workbook using "Open and Repair" or using a third-party excel repair tool.
If the pivot table is based on an external data source, such as a connection to a database or another file, make sure that the connection is still valid when you reopen the file.
Ensure that you are using a compatible version of Excel to open the file. If the file was created in a newer version of Excel, opening it in an older version may result in the loss of pivot table structure or unsupported features.

Best Regards.

Share via

Pivot disappear after saving Excel file

2 answers

Your answer