[Mac 1]

When I receive spreadsheets via email, it open as a totally blank, grey sheet.

 

I am using Office 2010 and I suspect the spreadsheets are created on Office 365

 

I've tried:

 

Uncheck DDE

Disable Hardware Graphics acceleration in Excel 

Reset Excel file associations

Repair Microsoft Office

I have no add ins listed

 

Any suggestions would be gratefully received

[Advertisements]

The solution here:

https://answers.micr...74-9f6d8d532917

 

seems quite popular.

[RKinner]

The solution here:

https://answers.micr...74-9f6d8d532917

 

seems quite popular.

[Mac 1]

Hi, I've tried the solutions suggested however the problem still persists

 

I asked Microsoft for assistance but they said it was likely to be because Office 2010 is too old 

 

They suggested I purchase Office 365

 

I can open the spreadsheet on Office.com

 

Any other ideas please?

Edited by Mac 1, 28 April 2021 - 09:14 AM.

[RKinner]

Can you attach one of the files that doesn't open (or send it to me via a PM if you don't want it out in public)?

 

You may have to zip it up to get the forum to accept it.

[DR M]

This also seems to be a solution regarding Excel 2010:
 
Only do this if you trust the origin of the files.

• Open Excel, Options and then Trust Center.
• Go to Protected View.
• Deselect the box for Enable Protected View for files originating from the Internet.
• When you open one of these files you will get a warning message.
• If you click Yes, it will open the file. You can then save the file in the proper format for future work.

[DR M]

This also seems to be a solution regarding Excel 2010:
 
Only do this if you trust the origin of the files.

• Open Excel, Options and then Trust Center.
• Go to Protected View.
• Deselect the box for Enable Protected View for files originating from the Internet.
• When you open one of these files you will get a warning message.
• If you click Yes, it will open the file. You can then save the file in the proper format for future work.

[Mac 1]

Can you attach one of the files that doesn't open (or send it to me via a PM if you don't want it out in public)?

 

You may have to zip it up to get the forum to accept it.

This doesn't look like a file specific issue

 

I have looked at previous emailed files and I can no longer open files sent many months ago

 

Until last week, I could previously open these files with Excel 2010

 

I can successfully open them with Office.com

 

I can create and send files to myself and they will open ok

 

I feel its something to do with a windows update 

[Mac 1]

Thanks for the advice.

 

Unfortunately, the box was not checked

 

 

This also seems to be a solution regarding Excel 2010:
 
Only do this if you trust the origin of the files.

• Open Excel, Options and then Trust Center.
• Go to Protected View.
• Deselect the box for Enable Protected View for files originating from the Internet.
• When you open one of these files you will get a warning message.
• If you click Yes, it will open the file. You can then save the file in the proper format for future work.

 

[RKinner]

Have you tried backing out:

KB3115322, KB3115262 & KB3170008


if installed?

[Mac 1]

I cant see any of these updates on the update history page

 

There have been 2 recent Office 2010 updates including excel 2010

 

KB3017810 on 16th April

 

KB4504707 on 11th March

 

 

 

 

Edited by Mac 1, 28 April 2021 - 10:36 AM.

[RKinner]

What are the last updates you have?

[Mac 1]

W10 Update KB5001330

 

And a lot of Office 2010 security updates including Excel 2010 updates:

 

KB3017810 on 16th April

 

KB4504707 on 11th March

[RKinner]

Unless you have had the problem since March I would try uninstalling

KB3017810

[Mac 1]

Hi

 

I've uninstalled the update and rebooted but no change 

[RKinner]

Try KB5001330 then.  Lots of reports of it causing problems (tho none about your problem)