Excel Workbook sharing

Hi,
I have an Excel Workbook that is Shared on a common network. If I have it open and another person opens the workbook and makes a change, I do not automatically see the change on my open workbook. Do I need to refresh (is that possible??) my Excel sheet? I do not want to close my open workbook and re-open every time I want to see all the changes.

Please advise.

Vik.
viks_mehtaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
luconstaConnect With a Mentor Commented:
You should get the updates automatically when the file is saved - at least this is the default behavior on Excel 2010, but, as Microsoft states in Use a shared workbook to collaborate:
You can choose to get automatic updates of the other users' changes periodically, with or without saving, under Update changes on the Advanced tab of the Shared Workbook dialog box.
0
 
sparabCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.