LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Peter
 
Posts: n/a
Default Can I permanently delete/hide data within Pivot Tables?

Microsoft Excel 2002

I have 155 clients which I need to run Pivot Tables for! All with the same
pivot table layout.

Is it possible to run the Pivot table with the 155 clients as a Template
basically, then somehow delete or permanently hide the data leaving only one
client, so that I can save multiple copies for each of the individual clients?

Or can I set up a pivot table where I can automatically feed in parameters?
Client details are stored on an Oracle database!
 
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
need to clear data references in pivot table report Mikeeusa Charts and Charting in Excel 3 April 28th 05 08:57 PM
Pivot table - printing specific data Doug Excel Discussion (Misc queries) 1 April 24th 05 08:29 PM
Do Pivot Tables have an automatic data range expansion? David.c.h Excel Discussion (Misc queries) 1 March 26th 05 12:55 AM
Pivot table of data in more than one worksheet Rehan Excel Discussion (Misc queries) 1 March 24th 05 09:32 AM
Need Formula to display pivot table source data Don S Excel Worksheet Functions 3 February 23rd 05 10:13 PM


All times are GMT +1. The time now is 01:12 AM.

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"