Hi,
Is there a way to auto refresh/ update the data on some worksheets and not others? I have a workbook with 4 worksheets. Worksheet 1 (WS1) is for input. WS2 and WS3 are for storing data from WS1. WS4 is also for storing data... but only data for use in pull down menus.
Hence, with multiple users, I would like to have WS2 and WS3 refreshed every 60 seconds. But I don't know how to do that.
I only know ThisWorkbook.RefreshAll.
Any help would be appreciated, thanks!
Is there a way to auto refresh/ update the data on some worksheets and not others? I have a workbook with 4 worksheets. Worksheet 1 (WS1) is for input. WS2 and WS3 are for storing data from WS1. WS4 is also for storing data... but only data for use in pull down menus.
Hence, with multiple users, I would like to have WS2 and WS3 refreshed every 60 seconds. But I don't know how to do that.
I only know ThisWorkbook.RefreshAll.
Any help would be appreciated, thanks!