8
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?
I was just trying the same thing--looks like the answer is still "NO", there is no F5 style refresh for Excel. I also found it impossible to open a file from Excel's most recently used list as read-only (You have to go into the file browser before you can do that)... And you can't make your currently open spreadsheet read-only... And Excel allows you to enter text into a read-only spreadsheet... All very annoying. – Bill K – 2018-02-05T22:00:22.077