Share via

Excel pivot tables cause loss of raw data when saving and reopening file - Why

Vijay Yandapalli 5 Reputation points
2023-09-28T10:04:36.7633333+00:00

Hi Team,

I am using Microsoft 365 subscription. In excel sheet I am having raw data once I make pivot tables using the raw data then i am saving the file. once i open again that file i am getting only pivot tables, my raw data is missing. Please help me with this.

Thank in advance.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,930 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,904 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 25,071 Reputation points Microsoft Vendor
    2023-09-29T06:48:21.92+00:00

    Hi,

    How did you get the data source? Did you get the data from external connection?

    What kind of file format did you save?

    Where did you save the Workbook?

    Did this problem appear in all Workbooks?

    Try to create a new Workbook in desktop with .xlsx file format and check if this issue still exists.

    Please be a bit more precise to explain your provide or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.