Code to set pivot table link to source file on each open

[jdttek]

I have a pivot table on which the link to the source file and range was proerly set using the wizard. Someone tried to change the link (on purpose or by mistake, I'm not sure)and srewed up the link. I somehow need to set or confirm the intended link each time the Pivot table is opened so that this does not happen again. Any suggestions on right VBA direction to head wld be greatly appreciated. Thanks

jdttek

 

[SkipVought]

Hi,
You could write some code in the Worksheet_PivotTableUpdate event that would maintain the source data link.

Use the macro recorder to see how the Pivot Table responds to such a change. If the source data changes, just stick it back in. Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com