Change Database name in Query for a Pivot Table
I need to deploy a excel worksheet that have a pivot table
that retrieve data from a SQL Server but when i refresh
the pivot said a message that the object doesnt exist.
This is beacuse the SQL is refer to the table with
database name.owner.table name and in the new installation
i dont have the same database name. How can i change this
in any way?
Thanks
|