Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Problem with Book1

Problem with Book1

Problem with Book1


I am running W10 with Office12 -(Excel 2007). When I open Excel, Book1 opens like it should, however, instead of filling the window it only occupies the upper 1/3. I must have done something wrong to cause this to happen. I would like to get Book1 to open and fill the page like it used to. I tried to save Book1 as Book.xlt and place it in the XLSTART folder but that didn't work.

I was thinking that I need to find where the real Book1 is stored and save a new copy there but I have not been able to find it.

I appreciate any help and advice you can give me.

Thanks in advance!

RE: Problem with Book1

Try to maximize workbook window(s), close excel and reopen excel and the workbook. As far as I remember, excel 2007 is a multiple document application, it keeps document window state according to recent document state or current status if any document is open.


RE: Problem with Book1

I don't know if this will help, but I've just done a quick test with Excel 2007. It appears that it remembers the state of the outer window, but not that of the individual document. In other words, if you open Excel, maximise it, close it, then open it again, it will open maximised. Similarly, if you un-maximise it, it will open un-maximised (with the same window size and position) next time.

However, if you maximise the outer window but not the actual document (the worksheet), then it appears that both the outer window and worksheet will be maximised the next time.

I can't guarantee these results are consistent, as I've only done a quick test. But, if they are - and assuming you are launching Excel from a shortcut - all you have to do is to go into the shortcut's properties and set the Run parameter to Maximised.


Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: Problem with Book1


Thanks for these ideas. I will give them a try and see if I have success.

RE: Problem with Book1


Checking back. It worked but only after a reboot. Thank you so much!!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close