Hi,
Scratching my head over trying to get pivot tables to automatically update every 4 minutes.
I have 3 worksheets:
worksheet 1: SCANNER, this sheet pulls in data externally using an =RTD links
worksheet 2: RAW, this manipulates the data above, and this is the data used to create the pivot tables
worksheet 3: SUMMARY, the pivot tables are here, there are 9 of them.
Worksheet RAW, changes every so often, and every 4 minutes I would like to have the pivot tables AUTO REFRESH
to make sure its using the latest data from RAW.
I see options to autorefresh on the opening of the workbook, but cant see anything to REFRESH EVERY X MINUTES.
Is there any way to do this with VBA ?
Bookmarks