In the example pictured, I inserted the file name and path fields into my header to the left, and the date and time fields in my header to the right. Also did you try the FixIt for me option listed here; Actually I mistyped and it is 2013 which I have corrected. There is no any warning message appears related to the issue. If these steps do not resolve the problem, go to Method 4. Most interface options are disabled in that mode on top of that.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 on this site the. The below-given solutions work well in both the cases grey screen and white screen issue, so try them in your case. You can hide sheets, rows, and columns and prevent changes to worksheet cells. In this condition, we need to change the default Excel template. But I finally found a solution! All the shortcut keys and descriptions were maintained, but more importantly, I didn't get a second copy of Excel opening every time I opened a worksheet from Explorer.
Step 1: Create a new workbook, and format one worksheet as you need. If this is a bug, it's taking so long to fix it that I'd guess it affects very few users. When creating a new workbook, Excel also offers to give you a flying start by using a template. I continue to have the same issue i. However, I am not willing to uninstall my software just now because I'm working on an important project and can not afford to lose time on this issue. At you can view over 850 free Excel video lessons just like this one.
If these steps do not resolve the problem, go to Method 6. When the users double-click on an Excel file or on the workbook icon, the program starts but a blank screen appears with a white screen or in some cases grey screen instead of the projected file. We regret being unable to individually answer all submitted questions. As I see it, Microsoft knows of this problems and it's up to them to provide a downloadable fix. Method 6: Disable hardware acceleration To work around this problem, disable hardware acceleration until a fix is released by your video card manufacturer. Automatically open a workbook template or worksheet template when you start Excel You can save workbook settings that you frequently use in a workbook template, and then automatically open that workbook template every time that you start Excel. Step 2: Remove all worksheets in this workbook, except the worksheet you formatted.
Thereafter, newly inserted worksheets will contain all the modifications included in your Sheet. Click on Disable and that's it. However this is not limited to Excel 2016, Excel 2013 users are also facing the same issue. I had this issue as well. It was there so I tried deleting and recreating it to no avail just a big pain in my butt with the amount of macros I have. Every type of people including student, businessman, employee etc.
Click Browse to open a workbook that is not on the list. However, this is possible to utilize this option to open excel sheet at startup in certain version. Method 4: Repair Office Try to repair your Office programs. Despite it, always create a valid backup of your crucial Excel data and as well scan your system with good antivirus program for virus and malware infection. In my case I simply couldn't delete macros workbook as it was full of macros. Note For the Microsoft Office 365, you need to click the Change option above the programs list, select the Online Repair option on the next screen, then select the Repair option.
And try opening the Excel workbook again. What helped me was to make personal. Since bothwere instqalled last year, I suspect that neither was involved. My problem was that I had a Personal. Use some keyboard shortcuts like Alt-F-S or Ctrl-S or F12. My guess would be that it is a file association issue or something from the old Excel version that causes the issue. Repair Microsoft Office The Microsoft Office application, and specifically the Excel application, may not be functioning properly, requiring you to repair it.
Tips The above steps will reset the default file associations for Microsoft applications. That's because it's over to the right hand side out of view. The Windows 8 screen you're looking at now has just been installed on this computer. Would you like to answer one of these instead? To save a workbook as the default template, create the workbook, setting all the appropriate properties and options. Option 6: Repair Office Microsoft Office 2016 comes with two repair options. There should be a small window with a progress bar to show you the repair status.
However, this is a working solution that helped many users to open the Excel by troubleshooting the Excel not opening White or grey screen displays issue. Right-click the PivotTable and select PivotTable Options. The Excel file appears blank with no cells, no column or rows names, and no gridlines. We then removed the excel plugin again. Unfortunately, none of the above worked for me. For an Office 2013, Office 2010, or Office 2007 installation To repair Office 2013, Office 2010, or Office 2007, follow the steps in the following Office website topic: If these steps do not resolve the problem, go to Method 5. You can also track your progress through the course and print a certificate upon completion.