Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Using Excel 2010, I have a spreadsheet that is used by 3 different people at any one time. But if one person has the spreadsheet open on there PC the other people can only view it as read only. I have since shared the workbook and put the spreadsheet on a shared network drive and now they can all view the spreadsheet at the same time and edit it at the same time.

The problem is that nobody can see the changes that the other users have made unless the close out of the spreadsheet and open it up again to view the changes. I have checked the settings of the shared workbook and on the advanced tab have tick the option that updates the information every 5 minutes but the information does not update until you close out and open the spreadsheet back up again.

How can I fix this problem?

share|improve this question
seems that it will auto update when you save the document – wilson Jun 23 '12 at 3:35

In Excel 2010, with the workbook to be shared open, select the Review tab and you will see the Changes section of the ribbon.

enter image description here

Click Share Workbook to select options. On the Advance tab the Update changes is in the middle of the window. Adjust accordingly. Remember to save changes when done.

enter image description here

Here are detailed instructions from Microsoft for Excel 2010; use a shared workbook to collaborate

share|improve this answer
Sorry we are using Microsoft Excel 2010. The spreadsheet is designed for the users to input prices for the products we sell and ship out these prices are always changing so if one user puts in the new price for the product and it doesn't update calculations will be wrong by the other users – Mike Jun 22 '12 at 14:50
Thanks for the additional details. You can use F9 to update calculations manually or set it to automatic in options from the File tab. – CharlieRB Jun 22 '12 at 15:10
To complete CharlieRB's answer, the refresh setting is a local one and therefore needs to be updated for all users. It's not linked to the file being viewed. – user360347 Aug 21 '14 at 20:08
What "refresh" setting are you referring to? – CharlieRB Aug 22 '14 at 11:02

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .