| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does the data shift out my outline when I refresh the Pivot table? | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Pivot Table Data Filter Problem | Excel Discussion (Misc queries) | |||
| Pivot Table Data Field Query | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Threaded Mode
