MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot tables


Posted by E.G. on August 19, 2001 10:06 AM

I have a file with pivot tables, how can I convert back to a regular spreadsheet?


Posted by Dax on August 19, 2001 1:48 PM

If you highlight the whole worksheet, Copy, Paste Special, Values this will remove the pivot table properties.

HTH,
Dax.