New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.


Auto save in shared excel file

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at

Auto save in shared excel file

Postby kshar » Tue Mar 13, 2012 1:40 am


I and couple of my team we usually work on shared file everyday, and i am not able to track the update done by other team member, so i was thinking if ther could be a way like promting every user to save the file every five minute or three will be easy to track the update as in excel until and unless the file is saved we cant see the changes. I need you suggestion on it.

  • 0


Re: Auto save in shared excel file

Postby Sisyphus » Tue Mar 13, 2012 4:20 am

Hello kshar,
According to this link
each user of a shared workbook can set his own Autosave options. The article applies to Exel 2002 but should still be valid. Have you tried getting your users to set their individual autosave options?
Tools/Options - Save tab.
  • 0

Have a great day! :D

I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Former Moderator
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010

Re: Auto save in shared excel file

Postby kshar » Mon Mar 26, 2012 3:00 pm

Hi Sisyphus,

Thanks for the response, but that does not work we have tried we use office 2007.
Yes there is autosave tab but enabling that does not do anything.

Further help will be apreciated
  • 0


Re: Auto save in shared excel file

Postby MindDrive » Wed Aug 21, 2013 5:20 pm

I know it's been a while, but hopefully this will help you or someone else. It sounds like Share Workbook options will help when you first share the workbook. Within "Update Changes", select Automatically every X minutes, and also select "Save my changes and see others' changes."
  • 0

Posts: 1
Joined: Aug 21, 2013
Reputation: 0
Excel Version: 2010

Return to General Excel Questions

Who is online

Users browsing this forum: Baidu [Spider] and 4 guests