Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default Excel should undo/redo after saving a file--just like Word.

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   Report Post  
Mexage
 
Posts: n/a
Default

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   Report Post  
J. Banuelos
 
Posts: n/a
Default

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   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening an Excel File jedi249 Excel Discussion (Misc queries) 5 April 16th 05 11:44 PM
Excel file modification date GROSNER Excel Discussion (Misc queries) 5 March 4th 05 01:19 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM
Opening and saving Excel 2003 file from Excel 97. Rodrigo Excel Discussion (Misc queries) 2 December 12th 04 02:17 PM


All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"