Saturday, October 24, 2015

Reload spreadsheet in Excel 2010

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

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...