 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / April 2005need to clear data references in pivot table report
I have a sheet that records registration data. It is supported by different Pivot Table reports. The data in the main sheet changes twice a year and I need to find a way to clear the references that the reports use (as in 'show all', 'blank', etc.). I can clear the data from the main sheet, but the reports hold the data references. It is not affecting the reports functioning, it is just creating a HUGE reference list. There are instructions here for clearing old items from a PivotTable dropdown list: http://www.contextures.com/xlPivot04.html > I have a sheet that records registration data. It is supported by different > Pivot Table reports. The data in the main sheet changes twice a year and I > need to find a way to clear the references that the reports use (as in 'show > all', 'blank', etc.). I can clear the data from the main sheet, but the > reports hold the data references. It is not affecting the reports > functioning, it is just creating a HUGE reference list.  SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Thank You!! It worked except for one tough field which I can live with. It is astonishing to me how little MS helps with Pivot Tables in general. Thanks again. > There are instructions here for clearing old items from a PivotTable > dropdown list: [quoted text clipped - 7 lines] > > reports hold the data references. It is not affecting the reports > > functioning, it is just creating a HUGE reference list. You're welcome! Thanks for letting me know that it helped. > Thank You!! It worked except for one tough field which I can live with. It is > astonishing to me how little MS helps with Pivot Tables in general. Thanks [quoted text clipped - 11 lines] >>>reports hold the data references. It is not affecting the reports >>>functioning, it is just creating a HUGE reference list. SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.