"Get External Data" issue (Excel 2007)

Hello all :-)

I have an .xlsm file with 15+ Pivot Tables.
There is also "Raw Data" Tab in that file.
"Raw Data" is the source data for all Pivots.

I want to remove "Raw Data" from that file and use External Data for Pivots.

I've created (successfully) external Excel file with "Raw Data".
I go to "Data" Tab -> "Get External Data" -> "From Other Sources" -> "From Microsoft Query".
There is a connection for my "Raw Data" file.

Issue:

Currently all 15+ of my Pivots are still pointing to the tab with "Raw Data"
and when I go to "Options" tab -> "Change Data Source"
then my "Use an external data source" is grayed out (not able to select it).

Any way to fix it?

Thanks!
Michael