How many versions would you say is enough

josvill2010

New Member
Joined
Jun 1, 2011
Messages
40
Office Version
  1. 365
Hi,

I was wondering if you would have any advice when it comes to save a new version of your workings.
Lately, i have found myself saving a version after another making my folder looks very untidy. What would you advice to keep your versions nice and tidy?

When do you decide a new version is needed? I have seen people using almost a version per day..
I am afraid to move old version to a new folder called 'old' and for all the vlookup links to stop workings.



Best Regards,
jsoe
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Hi there. This is very much like asking 'how long is a piece of string' The answer will vary wildly depending on a number of factors. I list a few here:
-complexity of the workbooks (how easy to recreate)
-how frequently they are updated
-whether you are on a stand-alone machine or network (if a network there should be backup procedures in place for you)
-how stable is your working environment (machine crashes, excel crashes, etc) personally I have had issues with excel corrupting my workbooks if I have a lot of odbc connections in.
Excel has a 1 level backup feature built in (it always saves the backup to the same folder) - to use it you need to do a save as..., then click on the Tools option at the bottom, select General Options and check Always Create backup

You could set up a simple batch process that copies all your sensitive files to a backup location (providing you move them back into the original folder if you need them, before opening, the links won't get changed) and then set that up to be run automatically once a day (or however frequently you feel necessary).

Whilst not an answer, I hope these thoughts are of some assistance.

John
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,239
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top