Refresh without closing and reopening

[robertdseals]

Hello,
Does anyone know a way (without using a macro) to refresh a spreadsheet (if I have it open in read only) without closing and reopening it?

 

[kpark91]

If you mean calculating formulas.
You can press "Calculate Now" or F9

 

[robertdseals]

Sorry. I mean if someone else has it open and makes changes and I have it open "read only" how can I see their changes without closing and reopening?

 

[kpark91]

There's not a way I know of as opening file with a certain attribute cannot be changed when opened.

If it's a shared book, the person who's made changes must save the file then close
then you can open and see the changes made.

Any other takers?