View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Juan Alvarado Juan Alvarado is offline
external usenet poster
 
Posts: 1
Default 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