Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing PivotCache SQL Database
I have a worksheet that has pivot tables that link to an SQL database with a
set structure. I'd like to use this worksheet on many other databases. They'd all have exactly the same structure but the name and perhaps location would be different. Can I somehow change the location of the database the cache refers to without recreating all of the pivots? I did something similar in Access. All I needed to do is go to the linked table manager and change the source database. Any ideas? Thanks. Thanks. - John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Database links? | Excel Discussion (Misc queries) | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Can I add an item to a PivotCache with VBA? | Excel Discussion (Misc queries) | |||
Changing text case in entire database column from JOHN to John | Excel Discussion (Misc queries) | |||
Remove specific Pivotcache fields | Excel Discussion (Misc queries) |