Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Clear pivot table drop down with VB code

Status
Not open for further replies.
ETID

ETID

Programmer
Jul 6, 2001
1,867
US
I have a pivot table based on ODBC linked data, when I requery the ODBC data, the drop downs in the pivot table contain both the old query items as well as the re-queried items.

Is there a way to clear the drop down items before I re-query the ODBC?

:cool:
 
Sort by date Sort by votes
What no takers?...you cowards :), just kidding
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Pivot Table Issue
Replies
6
Views
227
Andrzejek
Andrzejek
remeng
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
1K
remeng
remeng
pendle666
  • Locked
  • Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
197
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
900
shytott
shytott
E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
360
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top