Auto update some spreadsheets inside a shared workbook and NOT others

S

skylark99

Joined
Jul 27, 2012
Messages
1
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code condition 3
PivotTable.Refresh woes 1
Compare 2 Sheets and Extract Unique Info to a 3rd Sheet 7
this action will cancel a pending refresh data command 3
Import/Copy some data from one workbook to a similar workbook 11
Data or the charts does not refresh in a Shared workbook. 1
Can i make some worksheets auto and others manual calculation 2
Using Querytable.add to import data from a closed workbook 8

Top