Auto save in shared excel file

[kshar]

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

[Sisyphus]

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.

[kshar]

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