Refresh a read only file

[BGN]

Is there a way to refresh the data in a "read-only" file without closin
and reopening the file, each time someone else makes a change to th
file and saves it? I want to use this option when I did not make an
changes to the worksheet.

Sometimes when I make changes to a "read-only" and when the fil
becomes available for read-write access, it asks whether to save th
file under a different name or discard changes. Sometimes both th
options crash Excel. How can I see what other users changed to th
file since the last time I viewed the file? Is it possible?

Thanks for your help.

Regards,
BG

 

[Dave Peterson]

I've never had excel crash when I do either of these.

But I don't have a solution for you either. But you may want to look at sharing
your workbook so that multiple people can update it at one time.

(There's lots of stuff you can't do with shared workbooks. Take a look at
"features that are unavailable in shared workbooks" in excel's help.)

And lots of smart people around here say they have trouble with shared
workbooks. (I've been lucky--I haven't shared a workbook and won't if I don't
have to.)