Refreshing two pivots in different workbooks

[Roman12]

Hi there

I have approximately 14 different workbooks in one folder that need a weekly update. All of the workbooks contain two pivots. One Pivot is in the sheet called "claim", and the other sheet is a Pivot chart called "chart".

I have one Major Workbook in which I would like to have a Macro that would be able to refresh all the Pivots in the dissimilar workbooks.

Is that possible?

Thank you very much.

 

[Fazza]

Hi,

I think a code solution would need to loop through and open each file. This is straightforward though offers little advantage over a non-code approach.

Without VBA, set the pivot tables to refresh on file open. Such as right click from within a pivot table, take the 'table options' and then select 'refresh on open'.

Is that OK for you? Regards, Fazza

 

[Roman12]

Hi

I have searched some other threads with the same problem within Mr. Excel. The following user Analyst44 asked the same question and came up with some kind of solution. Do you think it would be possible to help me implementing his idea?

The following is the user´s name and thread title.

User: Analyst44
Title: Refresh Pivot Table in a *different* workbook

thank you

roman