zenchaotik
New Member
- Joined
- Nov 15, 2004
- Messages
- 2
Hi Everyone,
I am working with several Pivot Tables (24) in a spreadsheet which share a common External Data Source (containing multiple queries) on my workstation (it's an Access database). There is a report that uses data from the pivot tables to populate a summary worksheet.
The problem is I now need to move the access database onto our network, but I have not been able to find a simple way to "tell" the pivot tables the source has moved (I’m kicking myself for not developing this on the network). So, as a result, the report that uses these pivot tables won't be able to update after source is moved.... unless I go through the painful process of re-creating all the pivot tables (and update all my getpivot formulas on the summary worksheet).
It's painful changing the source from MS Query, and was wondering if there was a quicker to do this and re-creating the pivot tables will be time consuming too. Just curious if anyone had ideas (hopefully I provided enough info).
Corey
I am working with several Pivot Tables (24) in a spreadsheet which share a common External Data Source (containing multiple queries) on my workstation (it's an Access database). There is a report that uses data from the pivot tables to populate a summary worksheet.
The problem is I now need to move the access database onto our network, but I have not been able to find a simple way to "tell" the pivot tables the source has moved (I’m kicking myself for not developing this on the network). So, as a result, the report that uses these pivot tables won't be able to update after source is moved.... unless I go through the painful process of re-creating all the pivot tables (and update all my getpivot formulas on the summary worksheet).
It's painful changing the source from MS Query, and was wondering if there was a quicker to do this and re-creating the pivot tables will be time consuming too. Just curious if anyone had ideas (hopefully I provided enough info).
Corey
