Autosaving of workbook when they are opened

I have a workbook which has been shared to many peoples in the same network, and the workbook is quite big in size and sometimes the file crashes so i thought of saving the workbook each time it was opened, so it will be much better for me if i can get some VB code to do the same.

hi,
Excel 2010 will autosave on an interval of however many minutes you would like it to. just go to file tab, options, save and you will see "save autorecover every x minutes". hope this helps!

Also, if it is a shared workbook, you can set it to update on an interval. Go to the Advanced tab in the Share Workbook dialog box. You will see an option to "Update every X minutes". Below that is an option to "Save my changes and see other's changes".

As a further note, Excel's Share Workbook feature is known to crash frequently. When possible, it is best to find other methods to share your data.

Originally Posted by Whizbang

Also, if it is a shared workbook, you can set it to update on an interval. Go to the Advanced tab in the Share Workbook dialog box. You will see an option to "Update every X minutes". Below that is an option to "Save my changes and see other's changes".

As a further note, Excel's Share Workbook feature is known to crash frequently. When possible, it is best to find other methods to share your data.

Thanks a lot sirs.

Mr.Whizbang
as you have mentioned is ther any other option to do, as i am new to excel.

Originally Posted by bryanbak3

hi,
Excel 2010 will autosave on an interval of however many minutes you would like it to. just go to file tab, options, save and you will see "save autorecover every x minutes". hope this helps!

sir, really this is useful for me, thanks a lot.
but i have a doubt even though this option takes back up automattically it is going to back up on the setup intervals, is there any option to do the same when someone opens the file as i can avoid backing up the file unnecessarily.

I am unaware of any ways. Sorry.

Originally Posted by bryanbak3

I am unaware of any ways. Sorry.

ok sir thanks.

Originally Posted by muralidaran

Thanks a lot sirs.

Mr.Whizbang
as you have mentioned is ther any other option to do, as i am new to excel.

Other ways would be to use another application instead, like Access. Excel is not intended to be a multi-user platform. It has this functionality, but it is flawed.

http://blog.contextures.com/archives...ooks-in-excel/

If your users prefer Excel, then consider seperating your data from your reporting or entry. Create a read-only workbook that is used as a front-end. Then use VBA to import and export data as needed.

Originally Posted by Whizbang

Other ways would be to use another application instead, like Access. Excel is not intended to be a multi-user platform. It has this functionality, but it is flawed.

http://blog.contextures.com/archives...ooks-in-excel/

If your users prefer Excel, then consider seperating your data from your reporting or entry. Create a read-only workbook that is used as a front-end. Then use VBA to import and export data as needed.

thanks a lot for the link, one thing i decided is to learn access for my work since my requirements are more, but excel is my favorite as because it is very handy for the new beginers.

Yeah, Excel is pretty handy. But a properly designed Access database requires even less saavy-ness from the user. The whole point of a Database is to facilitate and simplify entry (while validating the input), and enable flexible reporting. Excel is too busy. With ump-teen million cells and hundreds of functions and features, it can be intimidating for a new user. They often stick to simple text and numeric entry and don't even attempt more complex actions. Access, though, puts the onus on the developer to take care of the techy stuff and let the user just do their job without distraction.

'Course it entirely depends on the requirements of the project. Some things are just not worth doing in Access. And quite often Excel really is the best tool.