How can I refresh a document I have open in Excel in read-only mode?

Question

I have an Excel document that is stored on a SharePoint Server, which I always have open on my computer in read-only mode because I need to refer to it.

Every so often, in order to get the latest changes, I have to close down the file and reload it again. Are there any options within Excel 2007 which allow me to simply refresh a document I have open in read-only mode to the latest version on the server?

Better still, is there a way where this could be done dynamically, without me having to hit refresh?

Answer 1

This might help:

a workbook author can create a workbook that automatically refreshes external data when the workbook is opened by selecting the Refresh data when opening the file check box in the Connection Properties dialog box.

This is where I get it. It's an interesting article. Does this help?