![]() |
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