ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel Should Have a History Function. (https://www.excelbanter.com/excel-worksheet-functions/46799-excel-should-have-history-function.html)

Ray M.

Excel Should Have a History Function.
 
Ever used graphic design programs and notice the history of each step that
you took to accomplish something. well that same functionality should be
incorporated into the next excel. as a student i often find it helpful to
look back at what i did to see how certain functions were executed. in
addition, a printing of the history should be available too, professors like
to see how you did things. simply showing the formulas for each cell does not
satisfy the need for a history function. I look forward to seeing this
function in the future release of excel. Thanks.

i am using excel 2003.

----------------
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...et.f unctions

Harlan Grove

Ray M. wrote...
Ever used graphic design programs and notice the history of each step
that you took to accomplish something. well that same functionality
should be incorporated into the next excel. as a student i often find
it helpful to look back at what i did to see how certain functions
were executed. in addition, a printing of the history should be
available too, professors like to see how you did things. simply
showing the formulas for each cell does not satisfy the need for a
history function. I look forward to seeing this function in the
future release of excel. Thanks.

....

How large do you want Excel files to become?

What sort of history? Absolutely ALL actions?

History of all changes in such a way that you can see every past state?

It's possible to use the macro recorder to record discrete sets of
steps taken during the creation of a workbook model. You could play
back such macros in initial sequence to recreate your workbook. So in a
way the functionality you're requesting already exists.

That said, don't hold your breath waiting for Microsoft to enable
recording of individual keystrokes and mouse actions while in Enter,
Point or Edit modes.


Max

... history of each step ..

Perhaps the current max 16 undo levels, which provides an undo history for
most actions performed in Excel ? And the number of undos could apparently
be increased according to:

http://support.microsoft.com/kb/162944/EN-US/
http://support.microsoft.com/default...b;en-us;211922

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--




All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com