Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Pivot tables lose of data fields when selecting

Having an issue with setting up pivot tables not to lose certain
fields if users de-selects some. For example I have muliple column of
data.

a, b, c, d, e, f

The user de-selects d, e, f; The next time they want to see D, E, F.
The go back to the drop down menu and only see Show all, a, b, c. Is
there anyway I can always keep them so they can reslect the data? I
can go back into the wizard and add them back but that is time
consuming and tring to teach that to 30 users is a bit tricky.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting Fields in Pivot Table Dan Excel Discussion (Misc queries) 2 April 8th 08 07:51 PM
Are there defaults for data fields in pivot tables (sum or count) willyindel Excel Worksheet Functions 0 February 22nd 08 10:00 PM
Grouping Data fields in Pivot Tables. [email protected] Excel Discussion (Misc queries) 2 April 8th 07 12:05 PM
Pivot Tables lose some formatting when Updated Jugglertwo Excel Discussion (Misc queries) 1 March 23rd 05 12:48 AM
Pivot Tables multiple data fields Excel GuRu Excel Worksheet Functions 2 December 16th 04 12:06 AM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"