Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.