We have a spreadsheet on a shared drive that one person updates and the rest of use just read. I was pretty sure that when we used Excel 2003, if the author updated the spreadsheet, Excel would notify the user and reload. Excel 2010 doesn't seem to be doing that, at least not automatically, so the author sends an email telling me about the changes, and then I have to close the file an re-open it. Is there a button somewhere which will just reload the file in a single click, or even better, automatically detect the changes and display them (the file is locked to me, I can only read it so I am not worried about losing changes)?
No comments:
Post a Comment