External Pivot Data

[jmenche]

Folks,

I had to move an access database to another location. Unfortunately, I have some pivottables that point to it. Is there an easy way to change the file path of the pivot data?

Thanks

:beerchug:

[Jan Karel Pieterse]

Have a look at my query manager, I'm interested to learn whether it handles a database change on pivot tables well:
www.jkp-ads.com/download.asp#querymanager (http://www.jkp-ads.com/download.asp#querymanager)
Alternatively, if it is just a matter of a search and replace of connection strings, my Flexfind tool might help too (see near top of the same webpage).

[jmenche]

Thanks. However, my new corporate laptop prevents me from adding anything to it without getting clearance first :-(.

I did manage to scour the internet to find that I needed to change the pivotcache.connection property.

:beerchug:

[Jan Karel Pieterse]

Nice that IT depts prevent you from using tools to enable you to work more efficiently :-)