Pivot Table Data Source

N

Nate

Every time I e-mail a 2007 Excel file, the pivot table data source is lost.
This never happened in Excel 2003. Any ideas on how to prevent this from
occurring? Thanks in advance.
 
G

Gary Brown

I don't have 2007 but in 2003 there is a checkbox to make sure that the data
travels with the pivot table.
Right click anywhere within the pivot table.
Select 'Table Options'.
The PivotTable Options window will appear.
In the 'Data Soruces' area at the bottom, make sure the 'Save Data With
Table Layout' checkbox is checked.
 
N

Nate

Thanks for the suggestion! When I went to "Table Options" I found "Save
Source Data with File", which I'm guessing is the equivalent of the check box
you mentioned in XL2003. It was already checked, so I'll try unchecking it
and see if that makes any difference. Sorry for the delay in responding.
 

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
pivot table source data expand to new entries when refresh? 4
Column limit for Pivot Table data source 1
Move and Copy Pivot Table and Source Data 4
Pivot Table Data Source 1
How can I change the source data reference to another pivot table? 2
Pivot table change data source 1
Change pivot table source data in Excel 2007 1

Top