Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 8th 10, 08:15 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1
Default Cannot Resize Workbook window

Have been working with the same Excel workbook for months. Today, when I
tried to open it, I found I could not maximize or resize the workbook.
The window control buttons (minimize, max, close) have disappeared and I
cannot get the resize arrow to appear so that I can resize it manually.

The workbook/worksheet is NOT protected and Full Screen view is NOT on.

Does anyone have any ideas other ideas on how I can restore resize
functionality to the workbook?

Mary

  #2   Report Post  
Old January 8th 10, 08:27 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 96
Default Cannot Resize Workbook window

A temp measure is to right click in the title bar at the top. This will give
Max/Min/Restore options. May not cure it but will help.

"Nightmry" wrote:

Have been working with the same Excel workbook for months. Today, when I
tried to open it, I found I could not maximize or resize the workbook.
The window control buttons (minimize, max, close) have disappeared and I
cannot get the resize arrow to appear so that I can resize it manually.

The workbook/worksheet is NOT protected and Full Screen view is NOT on.

Does anyone have any ideas other ideas on how I can restore resize
functionality to the workbook?

Mary

  #3   Report Post  
Old January 8th 10, 08:29 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default Cannot Resize Workbook window

You are positive the workbook is not protected under ToolsProtection?

Have you just started using GroupWise in an older version of Excel?

The missing icons on the Title Bar on ALL workbooks could be due to
GroupWise being enabled.

If that's the problem. See this MSKB article

http://support.microsoft.com/default...b;en-us;260199

Article is specific for 97 - 2002 but may be valid for other versions.

It gives a workaround (use the file menu) and instructions as to how to
remove the Groupwise add-in that is responsible for this behavior.


Gord Dibben Excel MVP

On Fri, 8 Jan 2010 12:15:02 -0800, Nightmry
wrote:

Have been working with the same Excel workbook for months. Today, when I
tried to open it, I found I could not maximize or resize the workbook.
The window control buttons (minimize, max, close) have disappeared and I
cannot get the resize arrow to appear so that I can resize it manually.

The workbook/worksheet is NOT protected and Full Screen view is NOT on.

Does anyone have any ideas other ideas on how I can restore resize
functionality to the workbook?

Mary


  #4   Report Post  
Old July 8th 12, 10:28 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 1
Default

Quote:
Originally Posted by Nightmry View Post
Have been working with the same Excel workbook for months. Today, when I
tried to open it, I found I could not maximize or resize the workbook.
The window control buttons (minimize, max, close) have disappeared and I
cannot get the resize arrow to appear so that I can resize it manually.

The workbook/worksheet is NOT protected and Full Screen view is NOT on.

Does anyone have any ideas other ideas on how I can restore resize
functionality to the workbook?

Mary
I'm not sure if this helps. But you can try it.

I just installed Microsoft Office for Mac - 2011.
As a result, I lost the bottom border of one of my most used workbooks. I also lost the bottom ribbon that allows me to move the columns horizontally. In addition, I lost the marker that allows me to manually resize the workbook.
I still could move the workbook around the screen but the view dimensions didn't change.

What was available to me was the top border of the workbook. I found out that if I grabbed this top border and crunched the whole workbook down toward the bottom of the screen, the vertical or up and down view of the workbook was resized. I just kept doing this until I got the vertical view I wanted with the bottom ribbon and manual resize marker both visible.


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
Excel: Expose whole window or at least top resize handles. Reinie Excel Discussion (Misc queries) 1 August 25th 09 04:11 PM
Can't get to bottom right corner of window to resize? I figured it Michael NoNOTooMuch Excel Discussion (Misc queries) 1 April 14th 08 11:06 PM
How to resize Data Form dialog window? Compucat Excel Worksheet Functions 1 June 8th 05 11:24 PM
Need to resize a worksheet window Hasta Pasta Excel Discussion (Misc queries) 5 January 8th 05 10:49 PM
Resize the workbook window is impossible Valeria Excel Discussion (Misc queries) 1 December 29th 04 11:30 AM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017