Excel Workbook opens 'blank' when double clicked via my documents

wezuk03

New Member
Joined
Oct 21, 2014
Messages
5
Hello, hope someone can help

When I open some documents via double clicking in my documents (not necessarily this folder, some are on shared drives) they open 'blank' like this Imgur: The most awesome images on the Internet

I can click around the document, and it would appear the cells are there - but I just can't see them.

Oddly, if I open the document through excel (file > open) then it opens correctly every time.

So far, a google has brought up nothing other than turning off hardware acceleration - which I have already done, and it hasn't made any difference.

Really hope someone can help. This is a fresh installation of Office 2013, as I re-installed it because it was happening previously and I thought a reinstall would fix it.

The pattern seems to be entirely random - documents that sometimes open fine randomly open blank, then the next day open up fine again.

Thanks in advance.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
If you use "View | Window | Arrange All" does the worksheet then become visible?
I have seen this problem when someone using dual monitors, saves the workbook from the second monitor.
 
Upvote 0
Yes it does - thanks for the workaround!

I guess it's just a bug with Excel saving on dual monitor setups then?

Thanks,
 
Upvote 0
It was some time ago when I was working for a company that experienced the problem - most of the staff were using dual monitors.
They were probably using Excel 2007/2010.
Some of them were using my "tools" add-in, so I provided a button on the Ribbon to make the worksheet visible.
The code that it ran was:
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
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,908
Members
448,532
Latest member
9Kimo3

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
Back
Top