Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 72
Default How to clear pivot table catche

How to clear pivot table catche. because the fileds dropdown list contains
earlier values. so is there any solution for this. If possible without VBA
code.


Advanced Thanks,
Vinod
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 477
Default How to clear pivot table catche

Goto:
http://www.contextures.com/xlPivot04.html
and take a look at #2 Programmatically Clear Old Items -- Excel 2002 or later
if that is you..
HTH

"Vinod" wrote:

How to clear pivot table catche. because the fileds dropdown list contains
earlier values. so is there any solution for this. If possible without VBA
code.


Advanced Thanks,
Vinod

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
How do I Clear old Pivot Table Fields that no longer exist snowman Excel Discussion (Misc queries) 2 January 9th 07 05:52 PM
Replace (blank) entry in a pivot report with clear cell PeterGilbert Excel Discussion (Misc queries) 1 November 6th 06 12:13 AM
How to clear the word '(blank)' from a cell in a Pivot Table Rob Conder Excel Discussion (Misc queries) 2 November 3rd 06 07:14 AM
Clear history from pivot table cchristensen Excel Discussion (Misc queries) 1 October 18th 06 09:47 PM
need to clear data references in pivot table report Mikeeusa Charts and Charting in Excel 3 April 28th 05 08:57 PM


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