Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-03-2016, 01:52 PM
Don Buelke Don Buelke is offline Reopen worksheet where I left off Windows 10 Reopen worksheet where I left off Office 2016
Novice
Reopen worksheet where I left off
 
Join Date: Aug 2016
Posts: 2
Don Buelke is on a distinguished road
Default Reopen worksheet where I left off

I use Excel to post client account records, some of which are many screens long. Every time I reopen Excel to make a new entry on a worksheet, it has defaulted to the top and I need to scroll down to the point to make a new entry manually. Doing a Ctrl-End sends me to the absolute bottom of the file's potential limit. Is there a way to change this default to simply leave the worksheet at the point it was saved?
Reply With Quote
  #2  
Old 08-07-2016, 08:59 PM
jolivanes jolivanes is offline Reopen worksheet where I left off Windows XP Reopen worksheet where I left off Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Posts: 91
jolivanes will become famous soon enough
Default

If I am working at row 456, save the file and close it and after that open it, it will open there where I was when I saved it, in this case Row 456.
It doesn't do that for you?
Reply With Quote
  #3  
Old 08-08-2016, 02:48 AM
xor xor is offline Reopen worksheet where I left off Windows 10 Reopen worksheet where I left off Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Can it be that your workbook contains a Workbook Open macro that sets Excel open at the top?
Reply With Quote
  #4  
Old 08-08-2016, 07:04 AM
Don Buelke Don Buelke is offline Reopen worksheet where I left off Windows 10 Reopen worksheet where I left off Office 2016
Novice
Reopen worksheet where I left off
 
Join Date: Aug 2016
Posts: 2
Don Buelke is on a distinguished road
Default

Quote:
Originally Posted by jolivanes View Post
If I am working at row 456, save the file and close it and after that open it, it will open there where I was when I saved it, in this case Row 456.
It doesn't do that for you?
No. I have about a dozen client columns and they all revert to top-of-page, regardless of the fact that I saved the entire file with each column left where I left off.

I converted, or I should say Excel automatically converted, these files from Apache Open Office, but I never had the issue there and I haven't created any macros or done anything w/ Excel 2016 on-line since I began using it a few months ago.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink: open the document only once, quit & reopen PP, hyperlink doesnt work anymore quanghuynguyenhua PowerPoint 0 10-10-2015 06:17 PM
I can open an email which has characters such as [ ] in the path but if i close and reopen it i get Davederave Outlook 0 09-25-2015 07:04 AM
Reopen worksheet where I left off Selected items in Combobox remain the same when closing and reopen document Attila Word VBA 3 01-29-2015 04:08 AM
Reopen worksheet where I left off How to summarise different worksheet to a summary worksheet samkiewhock Excel 1 09-06-2012 03:34 AM
Word loses image sizing when I reopen file rbz1949 Drawing and Graphics 4 06-24-2010 11:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft