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 / General Excel Questions / February 2008

Tip: Looking for answers? Try searching our database.

Value Field Name is lost in Pivot Tables...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RM - 29 Feb 2008 20:08 GMT
I renamed the value field names in my pivot table. When I removed certain
columns in the pivot table, then later want to add it, the name is lost along
with the settings (ie. sum, and number with no decimals).  

If possible, how can I make this where anytime I remove and add it back it
won't lose the settings?

Thanks,
RM

By the way, I'm using Excel 2007.
Jim Thomlinson - 29 Feb 2008 20:28 GMT
AFIK you can't. When you remove the dimension from the table the settings are
lost...
Signature

HTH...

Jim Thomlinson

> I renamed the value field names in my pivot table. When I removed certain
> columns in the pivot table, then later want to add it, the name is lost along
[quoted text clipped - 7 lines]
>
> By the way, I'm using Excel 2007.
RM - 29 Feb 2008 23:55 GMT
I thought so...darn it

Thanks for the reply!

> AFIK you can't. When you remove the dimension from the table the settings are
> lost...
[quoted text clipped - 10 lines]
> >
> > By the way, I'm using Excel 2007.
 
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.