Pivot Table Refresh wipes out all data

  • Thread starter Thread starter Leslie
  • Start date Start date
L

Leslie

I am stumped. I have inherited a spreadsheet. There is
one data sheet and several pivot sheets off that data.
If I just hit the refresh button on any of the pivot
table sheets, all the data in the pivot table
disappears. If I create a new pivot table from the same
data, I can update all day long. Any ideas what might be
going on? Why can't I refresh this data?
 
That can happen if the headings in the source table have been changed at all
from what they were when the Table was first created.
 
Turns out that when I open this same file in Excel 97,
everything works fine. It's only in Excel 2002 that this
happens! Anyway to update the file to work under Excel
2002?

Thanks,
Leslie
 
Hmmm, OK you got me curious now. Is this a file you could send me to take a
look at? I'll happily try it all versions from 97 to 2003 and see if it does if
for me.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh order when refreshing all in a workbook 1
Pivot Table Refresh not working properly 1
Pivot Table - Changes 5
Refreshing a pivot table 1
Refresh Pivot table data in Protected sheet 3
Pivot Table update 8
Pivot ungrouping on refresh? 3
Pivot table 1

Back
Top