Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Excel 2010 Cannot Open Maximized.

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 31-08-2011
Member
 
Join Date: Aug 2011
Posts: 45
Excel 2010 Cannot Open Maximized.
  

I have got Windows 7 Enterprise 64-bit edition and I have installed Microsoft Office 2010 Pro plus. Te problem is I cannot open the Excel workbook which I once saved to get maximized. The Excel will not open to maximize mode even when I set the shortcut default to go maximize. Is this a bug? What is the solution for this problem? Is there a fix/workaround for this?

Reply With Quote
  #2  
Old 31-08-2011
Member
 
Join Date: Apr 2009
Posts: 484
Re: Excel 2010 Cannot Open Maximized.

I also have the same beahviour. Annoying and definitely a bug, in my opinion; Though there is a workaround for this. You will have to edit a bear, You just have to place the following code in PERSONAL.XLSB, in the Workbook and save it:
?Private Sub Workbook_Open() Application.WindowState = xlMaximized
End Sub ?
Once you get the save, it is set to maximum size.
Reply With Quote
  #3  
Old 31-08-2011
Member
 
Join Date: May 2009
Posts: 525
Re: Excel 2010 Cannot Open Maximized.

It's the presence of a Personal Macro Workbook in C:\Users\< loginame> \AppData\Roaming\Microsoft\Excel\XLSTART\ folder (filename = PERSONAL.XLSB). It?s becoz of this file that excel is not opening as I desire. Move that file to another location, Excel will start maximized. It opens in Normal mode if I move it back or create a new one from the Developer tab.
Anyone else can solve this duplicate the same way? If so, then this is definitely a bug. A similar kind of bug was present in Excel 2007, there was a problem when Excel couldn?t close if the file was present in XLSTART folder. It seems MS has traded one bug for another.
Reply With Quote
  #4  
Old 31-08-2011
Member
 
Join Date: Aug 2011
Posts: 45
Re: Excel 2010 Cannot Open Maximized.

Yeah, that does solve the problem. It?s definitely a bug and seems like they have just imported the bug from the 2007 one.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel 2010 Cannot Open Maximized."
Thread Thread Starter Forum Replies Last Post
Excel 2010: Cannot open Clipboard Xbust Windows Software 5 18-05-2011 10:24 AM
Open New Window maximized in Internet Explorer 8 Nicole Kidman Technology & Internet 4 06-02-2011 11:37 AM
Open Emacs in maximized window as default in Linux brynhildur Operating Systems 4 12-11-2010 07:41 AM
Unable to open a Sample Excel file using Office 2010 Caelaan Windows Software 5 10-03-2010 04:14 PM
Unable to open excel 2010 files in seperate windows Abel18 Windows Software 5 19-02-2010 03:43 AM


All times are GMT +5.5. The time now is 12:54 AM.