Excel spreadsheets open blank.


  1. theweav
    Posts : 91
    Windows 10
       New #1

    Excel spreadsheet with macro opens blank.


    Dell Latitude E5500 laptop
    Windows 10 Professional
    Microsoft Excel Office XP Standard with 2007 Conversion

    I have created a spreadsheet that opened normally until I added a "Clear Contents" control & macro. Now when I attempt to open the file, it opens with a blank screen. Within that blank screen I can Open the spreadsheet. My Dell 660 PC with Windows 10 Home and the same Excel software works fine on that spreadsheet. Any help will be much appreciated.
    Last edited by theweav; 16 Jan 2019 at 11:14.
      My Computer
    Quote Quote

  3. theweav
    Posts : 91
    Windows 10
    Thread Starter
       New #2

    I finally got this to work. Maybe this will help somebody: Go to Apps and Features > Default Apps > Choose default apps by file type > .xlsm and set to Microsoft Excel. Mine was set to Microsoft Open XLM Converter. Then go to your open spreadsheet and select Save As. Under File Type select Excel 2007 Macro - Enabled Workbook. These settings worked on the Win 10 Pro laptop. Good luck.
      My Computer
    Quote Quote

 

  Related Discussions
For a long time I have kept detailed records from my phone provider personal analysis to ensure being on the correct package Throughout the csv files from the company downloaded have opened by default in Excel 2007 Home and Student, but suddenly...
I have a new dell Inspiron with Windows 10 and office suite. I plugged in a flash drive with spreadsheets on it. When I try to open them, Windows 10 TRIES to open them with Outlook 2016, and of course they won't open. WHICH APP is necessary...
Excel Opens Two Files With One Blank
in Microsoft Office and 365

I can't seem to catch a break since buying a new computer with Windows 10 and UltraHD. I've noticed that every time I open an Excel file, it not only opens that file, but it also opens a blank workbook as well. This has never happened to me on any...
Two days ago, Windows Update deleted my printer and its drivers from my system. I was able to get the drivers from Canon and put everything back together, but was not happy about it. Then this morning I found that another update had caused Excel...
In previous windows versions I could resize two spreadsheet windows and drag them side-by-side. With Win 10 if I click on a second spreadsheet it replaces the first. How do I get two Excel 2000 spreadsheets side-by-side to compare two versions??
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 19:07.
Find Us




Windows 10 Forums