Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
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
How do I work with part of a cell entry? JKB Excel Worksheet Functions 4 July 29th 05 11:09 PM
Work book formulas Jessica Excel Discussion (Misc queries) 1 June 9th 05 10:51 AM
Is there away to keep "auto save" from jumping to the first work sheet in the work book? Marc New Users to Excel 2 April 21st 05 01:27 AM
simultaneously work in a work book with other users Sweets Excel Discussion (Misc queries) 1 April 18th 05 07:35 PM
Using a cell reference to refernce worksheet in another work book [email protected] Excel Worksheet Functions 5 January 6th 05 06:26 PM


All times are GMT +1. The time now is 03:44 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"