How can I refresh a document I have open in Excel in read-only mode?
- by RoboShop
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?