Share via

Can I save pivot table in compatibility mode?

Dennis Bjorklund 0 Reputation points
2023-01-19T19:53:29.9733333+00:00

I'm trying to save a pivot table and I see the file is in compatibility mode will that prevent me from saving the pivot table?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,591 Reputation points
    2023-01-20T07:10:53.45+00:00

    Hi @Dennis Bjorklund

    Please refer to Tasadduq Burney's detailed reply.

    I do not suggest you save Pivot Table in Excel compatibility mode.

    Besides, here is a similar thread "Pivot table doesn't work after save in compatibility mode".

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.

    1 person found this answer helpful.
  2. Tasadduq Burney 8,406 Reputation points MVP
    2023-01-19T20:05:43.07+00:00

    If a pivot table is saved in compatibility mode, it may prevent you from using certain features of the pivot table. For example, you may not be able to refresh the pivot table's data, or you may not be able to change the pivot table's layout. However, you should still be able to save the pivot table itself. To ensure that you can use all the features of the pivot table, you should save the file in the native format of the program you are using (e.g., .xlsx for Excel) instead of compatibility mode.

    0 comments