multiple users access and make changes to excel spreadsheet, at seperate times, but only the person who made the last change can see said changes. need to know how to set this up so any user can see the changes made by previous user. the file is saved to a shared network drive.

Hi,

Could you help me with more information below, so I can understand better on this issue:

1. Is there a fixed sequence of editing the Excel spreadsheet?
2. Does every change along with a save action?
3. Do you mean only the user made the last change can see all the changes but others cant by but only the person who made the last change can see said changes
4. What is your network drive? Is it one drive or other network drive?

Please kindly provide me above information, thank you.

Hi,

Could you help me with more information below, so I can understand better on this issue:

1. Is there a fixed sequence of editing the Excel spreadsheet?
2. Does every change along with a save action?
3. Do you mean only the user made the last change can see all the changes but others cant by but only the person who made the last change can see said changes
4. What is your network drive? Is it one drive or other network drive?

Please kindly provide me above information, thank you.

• Proposed as answer by Chloe WangMicrosoft employee, Moderator Thursday, May 07, 2015 4:45 AM
• Unproposed as answer by Chloe WangMicrosoft employee, Moderator Thursday, May 07, 2015 4:45 AM

Hi,

Could you help me with more information below, so I can understand better on this issue:

1. Is there a fixed sequence of editing the Excel spreadsheet?
2. Does every change along with a save action?
3. Do you mean only the user made the last change can see all the changes but others cant by but only the person who made the last change can see said changes
4. What is your network drive? Is it one drive or other network drive?

Please kindly provide me above information, thank you.

• Proposed as answer by Chloe WangMicrosoft employee, Moderator Thursday, May 07, 2015 4:45 AM
• Unproposed as answer by Chloe WangMicrosoft employee, Moderator Thursday, May 07, 2015 4:45 AM

Hi, thank you for your response.

1. No, typically the spreadsheet is only used once everyday, but sometimes by a different user. One user at a time, do not need to share simultaneously with other users, one user at a time.

2. Changes are made and the sheet is saved. Not sure if I understood the question.

3 only the person who made the last change can see said changes

4. It is a network drive, not a cloud drive

I hope this helps clarify. Thank you in advance for your assistance.

Hi,

Thanks for the clarification. Could you please test one more thing for me?

 1. Create an other type file, like Word document.

 2. Change the Word document the same way as you change Excel. See if the issue can be reproduced.

Let me know the result, thank you.