Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Excel does not allow to Undo/Redo previous actions after the file has been
saved. In other words, if the user has made changes to the file, but wants to keep the previous version and forgets to rename the file and clicks the save button, the user cannot utilize the Undo/Redo options to go back and correct this. On the other hand, Word does allow this. Why doesn't Excel? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
![]() |
|||
|
|||
![]()
I strongly disagree with you Mr. Jerónimo Bañuelos; First of all, Word will
not save undo information in the file, nor will any program I know of (Microsoft or not). I believe this would lead to bigger file sizes, and some of them are large enough now. If the feature you mention about Word is "Track changes" it IS available in Excel (at least in 2003). To take a look at it follow these instructions: 1. On the Tools menu, click Share Workbook, and then click the Editing tab. 2. Select the Allow changes by more than one user at the same time check box. 3. Click the Advanced tab. 4. Under Track changes, click Keep change history for, and in the Days box, type the number of days of change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.) that you want to keep. Be sure to enter a large-enough number of days because Microsoft Excel permanently erases any change history older than this number of days. 5. Click OK, and if prompted to save the file, click OK. Note Turning on change tracking also shares (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) the workbook. I hope that helps; if it does, please rate my post. " wrote: Excel does not allow to Undo/Redo previous actions after the file has been saved. In other words, if the user has made changes to the file, but wants to keep the previous version and forgets to rename the file and clicks the save button, the user cannot utilize the Undo/Redo options to go back and correct this. On the other hand, Word does allow this. Why doesn't Excel? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#3
![]() |
|||
|
|||
![]()
Sorry if I was not clear. Undo/Redo does work in Word if the file is saved
but not closed. Ofcourse, after it is closed I don't think any program is capable of redoing/undoing actions when it is opened again. Again, Excel does not do this. -- Thanks, JB "Mexage" wrote: I strongly disagree with you Mr. Jerónimo Bañuelos; First of all, Word will not save undo information in the file, nor will any program I know of (Microsoft or not). I believe this would lead to bigger file sizes, and some of them are large enough now. If the feature you mention about Word is "Track changes" it IS available in Excel (at least in 2003). To take a look at it follow these instructions: 1. On the Tools menu, click Share Workbook, and then click the Editing tab. 2. Select the Allow changes by more than one user at the same time check box. 3. Click the Advanced tab. 4. Under Track changes, click Keep change history for, and in the Days box, type the number of days of change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.) that you want to keep. Be sure to enter a large-enough number of days because Microsoft Excel permanently erases any change history older than this number of days. 5. Click OK, and if prompted to save the file, click OK. Note Turning on change tracking also shares (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) the workbook. I hope that helps; if it does, please rate my post. " wrote: Excel does not allow to Undo/Redo previous actions after the file has been saved. In other words, if the user has made changes to the file, but wants to keep the previous version and forgets to rename the file and clicks the save button, the user cannot utilize the Undo/Redo options to go back and correct this. On the other hand, Word does allow this. Why doesn't Excel? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#4
![]() |
|||
|
|||
![]()
That is true and a similar feature like Word's Undo is something many of us
have been asking for, maybe next version? Regards, Peo Sjoblom "J. Banuelos" wrote: Sorry if I was not clear. Undo/Redo does work in Word if the file is saved but not closed. Ofcourse, after it is closed I don't think any program is capable of redoing/undoing actions when it is opened again. Again, Excel does not do this. -- Thanks, JB "Mexage" wrote: I strongly disagree with you Mr. Jerónimo Bañuelos; First of all, Word will not save undo information in the file, nor will any program I know of (Microsoft or not). I believe this would lead to bigger file sizes, and some of them are large enough now. If the feature you mention about Word is "Track changes" it IS available in Excel (at least in 2003). To take a look at it follow these instructions: 1. On the Tools menu, click Share Workbook, and then click the Editing tab. 2. Select the Allow changes by more than one user at the same time check box. 3. Click the Advanced tab. 4. Under Track changes, click Keep change history for, and in the Days box, type the number of days of change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.) that you want to keep. Be sure to enter a large-enough number of days because Microsoft Excel permanently erases any change history older than this number of days. 5. Click OK, and if prompted to save the file, click OK. Note Turning on change tracking also shares (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) the workbook. I hope that helps; if it does, please rate my post. " wrote: Excel does not allow to Undo/Redo previous actions after the file has been saved. In other words, if the user has made changes to the file, but wants to keep the previous version and forgets to rename the file and clicks the save button, the user cannot utilize the Undo/Redo options to go back and correct this. On the other hand, Word does allow this. Why doesn't Excel? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening an Excel File | Excel Discussion (Misc queries) | |||
Excel file modification date | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) |