Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table vanishes when refreshed
When I refresh my pivot table, either manually or via code, all the fileds
vanish. Not the values but the table itself goes back to where I have to place the fields in the table again. Is there something I need to do to keep the formatting for the table? Thanks, Mike |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table vanishes when refreshed
What version of Excel are you using?
Is the data in the same workbook? Do the field names change? Mike W wrote: When I refresh my pivot table, either manually or via code, all the fileds vanish. Not the values but the table itself goes back to where I have to place the fields in the table again. Is there something I need to do to keep the formatting for the table? Thanks, Mike -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table format changes when data is refreshed | Excel Discussion (Misc queries) | |||
Formats of pivot tables changes when data is refreshed | Excel Discussion (Misc queries) | |||
Pivot Table to be refreshed whenever the web query is being refres | Excel Discussion (Misc queries) | |||
Is there a way to compare a pivot table refreshed data to old one | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |