Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot field data disappears
I have a Pivot table that is set to refresh on open. It is based on a field
called Chartfields. Chartfields is a column of data that is also refreshed upon opening. When I open the workbook, a message box asks if I would like to enable macros and refresh data. I click yes, and it asks me if I want to replace the cells in my worksheet which includes the pivot table. I click yes and the data disappears. How can I auto refresh the underlying data in my pivot table without losing the data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Field in Field List but Not Source Data | Excel Discussion (Misc queries) | |||
Data Field button disappears? | Charts and Charting in Excel | |||
Pivot column disappears after external data refresh | Excel Worksheet Functions | |||
chart formating disappears when i refresh pivot table data | Excel Discussion (Misc queries) | |||
second axis disappears on pivot chart when page field changed | Charts and Charting in Excel |