[ExcelVBA] Source file path to be changed for all pivots in a worksheet

 

Dear Friends,
 
I have two excel working files, in which one is workings as a data base and another one is a Reporting file which is based on the pivots generated from the database file.
 
Everymonth, the database and the reporting file will be refreshed. I am unable to change the source file (database) for the new version of the reporing file.
 
Is there anyway to change the source file (database) path in the reporting file in single time to refresh the pivot based on the latest database dump. I am fine with manual change and VBA coding. It would be really helpful for my project.
 
Could you anyone help in the abvoe case?
 
Thanks & Regards
Manikandan Raghavan

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___