Auto Refresh

G

Gazz_85

I have a Excel spread sheet that updated at one terminal, read only copies
are available on the network however is there a way of automatically
refreshing the information in the read only copies without closeing and
reopening??
 
A

Alan McQuaid via OfficeKB.com

Hi,

I don't believe there is any option to update read only workbooks without
closing and re-opening. You could try sharing the workbook. Then, when anyone
wants to see the updated data they can click save. But, beware, Excel has
certain limitations with regard to shared workbooks and you should take a
look at the Help to consider these limits.

Alan
 
Top