LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default pivot table field dropdown list

Can someone please help me on this?

Everytime when I refresh my pivot table with new information, the field
dropdown list will automatically select the new field created due to the new
information. Is there any way I can prevent excel from selecting the new
field automatically? I want to keep the current format with only the fields
I have previously selected, but once I refresh the data, the pivot table will
also include new fields from the new data.

Please help!

Thank you in advance!
 
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
How do I remove a Calculated Field from the Pivot Table field list TheTraveler Excel Discussion (Misc queries) 2 April 9th 10 06:55 PM
How to make a field created a part of the Pivot Table Field List? drhell Excel Discussion (Misc queries) 0 January 29th 07 11:13 PM
Pivot Table -- Refresh Data in Field Dropdown Lists howard Excel Discussion (Misc queries) 1 December 22nd 06 03:02 PM
Duplicate values in Pivot table Page Field dropdown.. [email protected] Excel Worksheet Functions 1 June 28th 06 03:45 AM
no show all function in dropdown list in Pivot Table Eva Excel Discussion (Misc queries) 1 July 21st 05 02:28 AM


All times are GMT +1. The time now is 08:49 AM.

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"