Have opened file but cant view anything excel 2007

[ckoeleman]

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

 

[Derek Brown]

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:

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]

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