Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Avoid renaming page fields
Hi!
I have a macro that switches pages in a pivot table, which works as long as there is a matching page name for the string the macro wants to enter. When there is no such page, the macro simply changes the name of the current page. Do you have any ideas on how to avoid this? (I tried looping through the PivotItems to verify my input but it seems as if old items are cached, I only want to get the pages possible to choose in the current pivot table.) Thankful for ideas! /Marcus |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
Pivot Table Page fields | Excel Discussion (Misc queries) | |||
Why do old, unused values still show in my Pivot Page fields? | Excel Discussion (Misc queries) | |||
How to remove Drop Page Fields Here from Pivot Table | Excel Discussion (Misc queries) |