LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bonny
 
Posts: n/a
Default Dropdown list in PivotTable has deleted items. How to omit?

I deleted rows from my source data for a PivotTable, but when I refreshed the
PivotTable, the dropdown list for that field still contains "ghost" items
that were deleted. How do I get rid of them?
 
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 to pick one or more items out of a list, moving to new list, moving up or down. (form) Subteam Excel Discussion (Misc queries) 3 February 17th 06 04:13 AM
HELP! Nesting IF Statements/Dependent Dropdown List Thomas Peters Excel Worksheet Functions 4 November 30th 05 05:38 PM
Dropdown list question pennyrod Excel Discussion (Misc queries) 2 October 18th 05 09:55 PM
Dropdown list key selection TrevorM Excel Discussion (Misc queries) 1 October 3rd 05 07:57 PM
How do I find out what items are in one list but not in another l. Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 08:32 PM


All times are GMT +1. The time now is 01:21 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"