Pivot table change data source

[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!

 

[Dan DeHaven]

Any reason why you don't want to save the file as a 2007 file? Doing so
would probably open up the choice for you.

Dan

 

[mcarter]

I have to share the worksheet with others who do not have the new excel.