Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
refreshing data in a pivot table changes cell format
I have set up a pivot table to transfer data from a table when information is
entered into certain cells. When i refresh the pivot table the format of some cells in the table changes i.e. instead of the data being present in the centre of the cell it drops to the bottom right, this is becoming really irritating as i have to correct it all the time. i am planing on distributing the workbook to a number of people so would like to know how this could be prevented? Thanks in advance for any help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
refreshing data in a pivot table changes cell format
Unfortunately, the loss of formatting upon refresh of PivotTable is a known
issue by Microsoft. The generally reocmmended solution is to record a macro of you formatting the table as desired, and then having it run after you refresh. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "pistolpete" wrote: I have set up a pivot table to transfer data from a table when information is entered into certain cells. When i refresh the pivot table the format of some cells in the table changes i.e. instead of the data being present in the centre of the cell it drops to the bottom right, this is becoming really irritating as i have to correct it all the time. i am planing on distributing the workbook to a number of people so would like to know how this could be prevented? Thanks in advance for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to let pivot table chart's format stay after refreshing data. | Charts and Charting in Excel | |||
Pivot Table Refreshing of Data | Excel Discussion (Misc queries) | |||
Pivot Table does not remove old data when refreshing | Excel Discussion (Misc queries) | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Refreshing Data within a pivot table | Excel Worksheet Functions |