We cannot always trust files so its better to first convert them to actual excel format and then open them. After Excel restarted itself the issue was miraculously resolved!!!!! So double-click the title bar of the workbook. We tested Excel and the mouse and they both worked. I have been dealing with having a blank excel and the document I opened for quite some time. Currently we do not have any further workarounds.
I read the article, and I'll check the settings. Excel for Office 365 Excel 2019 Excel 2016 You double-click on an Excel file, but Excel doesn't open the file. Opening them without Protected View is a security vulnerability, and therefore files open from such locations are now blocked. To start viewing messages, select the forum that you want to visit from the selection below. Solution number 2 opening the properties and checking the unblock box allowed Excel 2016 to open the file.
I work in a very tightly controlled environment so was not able to uninstall the update myself. The following screen shot shows this option in Excel. Also did you try the FixIt for me option listed here; Actually I mistyped and it is 2013 which I have corrected. Note: All these are temporary solutions, so it may be possible that same issue again hampers your working. If you need to fix file associations, use our free to do it easily. We were able to fix this. The most common time I see this error is when Office 2007 or Office 2010 was removed and Microsoft 2016 was installed.
Be especially cautious when specifying a custom folder as a trusted location. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended. We realize this breaks compatibility with some existing solutions, and are working on getting these file types supported with Protected View. To do this, see the following Microsoft Knowledge Base article: Hotfix Package 1 for Microsoft User Experience Virtualization 2. I know I'm a year late on this but I just ran into this problem yesterday. Thank you for your patience. Method 6: Disable hardware acceleration To work around this problem, disable hardware acceleration until a fix is released by your video card manufacturer.
After the security updates Excel no longer will open the workbook because these files are not compatible with Protected View and there is no warning or other indication it was not opened. This at least allowed me to view the worksheets and the data. Stand Out as the employee with proven skills. These are in order from safest to riskiest. This seems to have sorted it. I did so and had no problems.
Thank you for the above information, unfortunately none of those workarounds has worked for me. If I select from Windows and open it to start excel, it opens completely gray with no tabs - only some spreadsheets though. I tried opening other spreadsheets and got the same result. Method 4: Repair Office Try to repair your Office programs. If Microsoft Excel opens a blank grey document or worksheet for you, then here are a few things you could do to fix the problem.
Relative to point number 2, to unblock individual files. An actual excel tab opens in the taskbar. I have older copies of these files from when I backup my computer, with the files saved individually not through the backup feature on a separate hard drive. I read the article, and I'll check the settings. But I do agree that something appears to have changed within the past couple of weeks, as this issue did not happen prior. It will leave your systems vulnerable.
I have Excel 2016 and am on Windows 7. They have to go back to the file and single click on it, then back to Excel and the file is displayed. You may want to move those files to some other location i. If these steps do not resolve the problem, go to Method 4. Enable the look-up wizard 8. This occurs on perhaps 20 of the 100 or so machines using this file and typically when they open an updated version from an email distribution. I wrote some many years ago, and continue to modify them.
This is now ready to roll out to about 600 users The file is there, not ignored. This is only for one user. If you use native formats e. Perhaps this could be a Windows or Ofiice update issue? Freya Office Newsroom Update : Our dev team is working on options to preserve security and assist customers with their workflow. We have a few options for workarounds. Another post from back in 2002 suggested deleting excel.
This direction needs to be more specific well, ok, here it goes then. They can be applied at a global level. Edge Out The Competition for your dream job with proven skills and certifications. I closed the spread sheet. I'm looking for an answer to this as well. All of the menus are intact in our situation.