#1
|
|||
|
|||
is there file 'version' control in excel
Hi
Just wondering if there is a File 'Version' Control function in Microsoft Excel? Perhaps in the Excel 2007 or Excel 2010 version. I have the Office 2003 suite and I cant find it there. I work as a Quality Manager and I regularly re-issue or revise hundreds of internal documents which are either in word or excel. What I do in Word is I use the File Version Control Function so I can save the old file behind the revised one so that I can always revert back if I want to review old versions. THis is a great function, but I dont think it is in excel? I do use Open Office Calc, the equivalent of excel and it seems to have this function, but I would like to know if any of the newer excel software has this ability. See attached screenshots of what I am talking about in Word and Open Office Calc. |
#2
|
|||
|
|||
Scenarios might work well for this. With scenarios, you specify "Changing Cells", and these are the only cells that can change from scenario to scenario. Then create a new scenario, give it a meaningful name and maybe comments, and you will be given the opportunity to change any of the Changing Cells. Repeat for other scenarios. You can then use a drop-down to change what scenario you have on screen. They are very neat.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel File Association | freeworld | Excel | 3 | 12-09-2011 10:07 AM |
How to find the version of word file? | mariaprabudass | Word | 6 | 04-29-2010 03:33 AM |
Some Excel File Will Not Open | cgoodlein | Excel | 5 | 05-19-2009 04:46 AM |
Control how Excel Opens | slew0302 | Office | 0 | 02-03-2009 01:30 PM |
Excel ->VB code for Checkbox (control toolbox) | kirkstyle | Excel | 0 | 08-16-2006 04:17 PM |