Data source for Pivot Table
 

Hi ,
I have a pivot table linked to a database , but the path of my
database change and now my pivot table did'nt work! Because he can't
recognize the new path!

Can change the path with vba programming with pivot table properties or
i need to rebuilt my pivot table again??

Thanks all...


--
AlexGasse
------------------------------------------------------------------------
AlexGasse's Profile: http://www.excelforum.com/member.php...o&userid=24923
View this thread: http://www.excelforum.com/showthread...hreadid=384619

Data source for Pivot Table
 

Recall the "Pivot Table Wizard" and back to step 2 then change the ne
path

--
keit
-----------------------------------------------------------------------
keith's Profile: http://www.excelforum.com/member.php...fo&userid=1624
View this thread: http://www.excelforum.com/showthread.php?threadid=38461