Auto save in shared excel file

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
Forum Rules Please read the forum rules before posting!

Put CODE tags around your macro/vba code in a post. Easy way to do this: select the macro/vba in your post and click the CODE button above where you input the text.

Auto save in shared excel file

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

Hi,

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.

thanks,
Kshar
  • 0

kshar
 
Posts: 2
Joined: Mar 13, 2012
Location: india
Reputation: 0
Excel Version: 2007

Re: Auto save in shared excel file

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

Hello kshar,
According to this link
http://office.microsoft.com/en-us/excel-help/administration-of-shared-workbooks-HA001013057.aspx
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

Sisyphus
Do what you can, with what you have, where you are. (FDR)
Sisyphus
 
Posts: 4437
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 198
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
-Kshar
  • 0

kshar
 
Posts: 2
Joined: Mar 13, 2012
Location: india
Reputation: 0
Excel Version: 2007

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

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


Return to General Excel Questions

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], Yahoo [Bot] and 2 guests

cron