Excel Pivot Table - Saving issue

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
 
S

Shane Devenshire

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.
 
P

Peter

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
 
Top