Have opened file but cant view anything excel 2007

ckoeleman

Board Regular
Joined
Jul 23, 2009
Messages
52
Hi all

I recently opened an excel file and then minimised the window of the file i was working on. I then tried to re-open it and I just cant. I tried exiting the program and re-opening the file but it still wont come up.

the trouble is it sais it has loaded the file because if I go to the ribbon and click 'view' then 'switch windows' it sais I am already in that window.

I am confused and would really appreciate the help

Thanks in advance
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Derek Brown

Well-known Member
Joined
Dec 26, 2005
Messages
2,390
Hello,
This happened to some of my work colleagues from time to time and seemed to affect only those that were using two monitors on their PC/Laptop. It started after upgrading to Excel 2007 and seemed to possibly be linked to the monitor on which the window was being displayed when minimized. On opening the file, there would only be a 'blue' area where the worksheet should be displayed.
I provided them with a macro to correct the problem:
Code:
Sub RestoreWindow()
    On Error Resume Next
    Application.Left = 1
    Application.Top = 1.75
    With ActiveWindow
        .Top = 1
        .Left = 1
    End With
    ActiveWindow.WindowState = xlMaximized
End Sub
I have never had that problem but I only use one monitor.
 

ckoeleman

Board Regular
Joined
Jul 23, 2009
Messages
52
Thanks for that. I will be sure to give it a try if it happens again.

However at the time I ended up fixing the problem by using the view tab and clicking arrange all and then ticked the 'windows of active workbook' box.

perhaps if this happens to one of your colleagues again you may be able to resolve it that way.


Cheers
 

Watch MrExcel Video

Forum statistics

Threads
1,123,442
Messages
5,601,695
Members
414,469
Latest member
Murrell78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top