Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 114
  • Last Modified:

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.
0
viks_mehta
Asked:
viks_mehta
1 Solution
 
luconstaCommented:
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now