Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep my pivot tables format from changing?
In my pivot table, whenever I select a new item through the drop down box of
my field my formatting gets screwed up. I have unchecked auto format table and I have checked preserve formatting. For example, I have a balance sheet and I use the drop down box to select different facilities in order to see their balance sheet values. Whenever I select a different facility, all of the row headings go from being left justified to centered and bottom justified to centered. I appreciate any advice you could give -- Thank You Andrew Edmunds |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Data Source on Multiple Pivot Tables at once | Excel Worksheet Functions | |||
pivot tables changing their formats when data is refreshed | Excel Discussion (Misc queries) | |||
Dynamically changing print areas for Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) |