Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

Renaming Page Fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
T. Jenkins - 02 Oct 2007 00:47 GMT
I have a macro that cycles through a pivot table page field, then extracting
data from the pivot generated by each page field.  Recently, the code entered
a page field value that didn't exist in the underlying data, and I now have
several items in this field that have been renamed.  I'm sure someone knows
the issue I'm referring to.

Is there some way I can reverse this?  The problem is that when Excel
"renamed" the existing fields, I ended up with fields in the table that do
not exist.  There must be some way of getting rid of the renamed fields,
right?

Thanks,
Todd
T. Jenkins - 02 Oct 2007 01:27 GMT
Ok, I figured out how to resolve this issue, but would like to add code to my
routine that checks for the existence of each page field before entering it.  
Can anyone make a recommendation?

Todd


> I have a macro that cycles through a pivot table page field, then extracting
> data from the pivot generated by each page field.  Recently, the code entered
[quoted text clipped - 9 lines]
> Thanks,
> Todd
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.