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!

Hi Peter,

Right-click on a Page Field and select Field Settings from the context menu,
then click the Advanced button. You can then choose to query the external
data source as you select the page item. So, if the client is a page field,
selecting one client retrieves data for only that client.

Ed Ferrero
http://edferrero.m6.net


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!