Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-11-2010, 11:34 AM
keithg keithg is offline is there file 'version' control in excel Windows XP is there file 'version' control in excel Office 2003
Novice
is there file 'version' control in excel
 
Join Date: Nov 2010
Location: Ireland
Posts: 3
keithg is on a distinguished road
Default 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.
Attached Files
File Type: pdf Word Versions.pdf (67.4 KB, 16 views)
File Type: pdf Version Control in Open Office Calc.pdf (98.1 KB, 23 views)
Reply With Quote
  #2  
Old 11-14-2010, 07:51 AM
Kimberly Kimberly is offline is there file 'version' control in excel Windows 7 is there file 'version' control in excel Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
is there file 'version' control in excel 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
is there file 'version' control in excel 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft