| 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 | |||
Linear Mode
