Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default Excel 2003 Pivot Table - deleted items still show in drop downs

I have an Excel 2003 Pivot Table. When I delete items in my Database, the
deleted items still show in the drop down list in my pivot table. How can I
delete these old items?
Thanks


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 770
Default Excel 2003 Pivot Table - deleted items still show in drop downs

John,

By following Debra Dalgleish's excellent advice he

http://www.contextures.com/xlPivot04.html

hth,

Doug

"John" wrote in message
...
I have an Excel 2003 Pivot Table. When I delete items in my Database, the
deleted items still show in the drop down list in my pivot table. How can
I delete these old items?
Thanks


__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4445 (20090921) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




__________ Information from ESET NOD32 Antivirus, version of virus signature database 4445 (20090921) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



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
Pivot Table Drop Downs dinadvani via OfficeKB.com Excel Discussion (Misc queries) 1 April 24th 08 02:02 PM
Pivot Table Drop Downs ChuckTheDuck Excel Discussion (Misc queries) 3 January 14th 08 08:37 PM
Pivot table drop downs Tony Excel Discussion (Misc queries) 1 July 11th 07 06:18 PM
reading into pivot table drop downs Lou Sanderson Excel Discussion (Misc queries) 0 October 19th 06 09:11 PM
Can Pivot table drop-downs act like AutoFilter RickJ7777 Excel Discussion (Misc queries) 1 May 20th 06 12:46 AM


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

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

About Us

"It's about Microsoft Excel"