ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to the cell in the last entry in a work book? (https://www.excelbanter.com/excel-discussion-misc-queries/171027-how-cell-last-entry-work-book.html)

Narnimar

How to the cell in the last entry in a work book?
 
I have lost my track while working when power supply interrupted in a work
book which is having many sheets. Thanks to recovered file by which I can
continue the work. But I forgot that in which cell of the sheet I was typing.
How to go to the same cell or last cell to continue in the recovered file?

Dave Peterson

How to the cell in the last entry in a work book?
 
If you're using xl2002+ and are writing about Autorecovery (not autosave), then
I don't think you'll find an easy way to accomplish this.

Autorecovery saves a copy of the file every so often (user selectable) and then
sits back and waits until the next interval. You could have edited lots and
lots of cells since the last autorecovery file was saved.

In fact, if I were you, I wouldn't limit my review to the last cell I could
remember editing. I'd look back to see which of my changes were the last saved.

For instance, I have autorecovery creating a backup every 10 minutes. I surely
wouldn't just want to look for the cell I was editing when the power crashed.



Narnimar wrote:

I have lost my track while working when power supply interrupted in a work
book which is having many sheets. Thanks to recovered file by which I can
continue the work. But I forgot that in which cell of the sheet I was typing.
How to go to the same cell or last cell to continue in the recovered file?


--

Dave Peterson


All times are GMT +1. The time now is 05:32 PM.

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