View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Annabel Annabel is offline
external usenet poster
 
Posts: 1
Default Refresh Data Pivot Table

I have a Pivot Table in Excel which was working well but now after a Refresh
Data does not show any values. The column and row headings print and new
values are visible but the actual cell contents and grand totals are blank.
The cells look as though they have no border and white shading. If I set the
formatting to clear then I still cannot see any values.

The data source is a different worksheet in the same Excel spreadsheet. It
has 17 columns and 331 rows. I am using Excel 2002 SP 3 on Windows XP SP 1.

What has caused this table to stop working after it worked well for so long?