Hi,

I currently have a macro button which refreshes the pivot tables in my
report.
The data source for the pivots is a db which sits in a folder which is
no longer accessible for users to view.

I therefore have a copy of the db in a shared area. I need to relink
my pivot tables to the new db source (path).

Is there anyway of changing the source without completely re-doing all
of the pivots?

Many Thanks in Advance.
Jason


--
jjj
------------------------------------------------------------------------
jjj's Profile: http://www.excelforum.com/member.php...fo&userid=7424
View this thread: http://www.excelforum.com/showthread...hreadid=532551