software

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: www.excelforum.com/member.php...foamp;userid=7424
View this thread: www.excelforum.com/showthread...hreadid=532551Yes there is a complex process.

Click on the pivot table wizard--gt; click back --gt; Get Data --gt;
At this stage an error msg will come on saying that the source data is not
found.
Click ok --gt;
Click on database button and select your database
Next msg appears quot;query cannot be edited by wizardquot;---gt;hit OK
Query screen opens
File--gt;New--gt;Select ODBC connectivity--gt;Select your databased file--gt; select
your table and then continue as usual.

See if this works... I generally use MS Access Database on which the Excel
pivots are built.

Manojquot;jjjquot; wrote:

gt;
gt; Hi,
gt;
gt; I currently have a macro button which refreshes the pivot tables in my
gt; report.
gt; The data source for the pivots is a db which sits in a folder which is
gt; no longer accessible for users to view.
gt;
gt; I therefore have a copy of the db in a shared area. I need to relink
gt; my pivot tables to the new db source (path).
gt;
gt; Is there anyway of changing the source without completely re-doing all
gt; of the pivots?
gt;
gt; Many Thanks in Advance.
gt; Jason
gt;
gt;
gt; --
gt; jjj
gt; ------------------------------------------------------------------------
gt; jjj's Profile: www.excelforum.com/member.php...foamp;userid=7424
gt; View this thread: www.excelforum.com/showthread...hreadid=532551
gt;
gt;