Pivot table change data source

M

mcarter

I have a pivot table that currently uses a range in another tab in the
worksheet. I would like to change the source to an external source, but it
will not allow me to do so.

I am using the newest excel in compatibility mode.
Under Options/ Pivot Table Tools/Change data source, it gives you 2 options.
The first option (currently checked) is "Select Table or Range". The
second option, Use external data source, is grayed out and will not let me
select this option.

Please help me figure out why I cannot change the source for my pivot table!
Thanks!
 

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

Pivot table data source 1
Excel 2007 pivot table source table 1
Pivot Table Data Source 1
Excel 2007 change data source 1
How can I change the source data reference to another pivot table? 2
Change pivot table source data in Excel 2007 1
pivot table source data expand to new entries when refresh? 4
Excel 2007 change pivot data source 4

Top