How do I set Excel 2007 pivot table default to not save source dat

B

Brian Poschner

How do I set up Excel 2007 so that all pivot tables created have the default
setting to not save source data with file?
 
D

Debra Dalgleish

It's not a global setting, so you'll have to change each pivot table
after you create it.
Perhaps you could create a macro that changes all the settings to your
preferred settings, and run that after you create a pivot table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot table source table 1
View Pivot Table Source data as a Data Table 6
How do I save Pivot Table Data 4
Column limit for Pivot Table data source 1
How to set default calculation method in pivot tables? 2
Change pivot table source data in Excel 2007 1
pivot table source data expand to new entries when refresh? 4
Pivot tables - memory issues - please help 2

Top