| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| View/Change Pivot Table Query | Charts and Charting in Excel | |||
| Change source of linked database query | Excel Discussion (Misc queries) | |||
| Database change in Query | Excel Discussion (Misc queries) | |||
| Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
| Try to change the path of the Query of pivot table in Excel 2000 | Excel Programming | |||
Linear Mode
