LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DB.
 
Posts: n/a
Default Opening workbook at sheet required.

I've a 3-sheet workbook that always opens at Sheet 2 - I want it to open
at Sheet 1.
I know that the standard answer here is "The workbook opens at the sheet
on screen when the file was last saved" but in this case it doesn't! How
can I get it to work in the proper way, please?

Another problem with this Sheet 2 (but not Sheets 1 & 3).
I've only about 34 rows in use but the sheet offers me 65536 rows
(available by scrolling) instead of the 70-or so rows that I would expect.
How do I correct this please?

TIA of any reply,
DB.


 
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 can update the data in an excel workbook without opening it dk Excel Worksheet Functions 0 April 14th 06 02:28 PM
Opening a workbook to a chosen sheet? renderingsanity Excel Discussion (Misc queries) 1 March 29th 06 02:17 PM
Copy sheet - Break Links to Old Workbook - Retain Formula. Mr Anonymouse Setting up and Configuration of Excel 1 October 15th 05 01:00 AM
Identify repeated cell entries in multiple sheet workbook as you . Trigger Excel Discussion (Misc queries) 0 August 17th 05 01:57 AM
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM


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