Change Database name in Query for a Pivot Table

J

Juan Alvarado

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
 
Top