Excel Pivot Table - Saving issue

  • Thread starter Thread starter Ross
  • Start date Start date
R

Ross

Hi, I have a file which contains several pivot tables, when I save the file
and reopen it for some reason it opens with all but one of the sheets as a
normal table as opposed to a pivot. Has anyone experienced this before/ has a
solution to my problem?

Thanks
 
What version of Excel are you using, 2007? Are you really saying that the
pivot tables convert to Excel Tables? The structure and layout of these two
objects is entirely different. You can get a table from a pivot table by
double click the grand total cell but that table is on a different sheet.
 
Are you sure you are saving from Excel 2007 to Excel 2007 and not TO
an older version. In that case some part of pivottable will get lost.

Regards

Peter
 
Back
Top