ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change Database name in Query for a Pivot Table (https://www.excelbanter.com/excel-programming/303492-change-database-name-query-pivot-table.html)

Juan Alvarado

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


All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com