If you recently upgraded to Excel 2016, Excel 2019, Excel 2021, or Microsoft 365/Office 365, you may experience an issue where OnePager fails to load your Excel file and therefore cannot create your report. Specifically, the issue happens if you launch OnePager as a standalone application (outside Excel) and then try import an Excel file that was created in an earlier version of Excel like Excel 2010 or Excel 2013. OnePager will attempt to load your Excel file, fail, and then return you to the start screen.
To see if you are experiencing an issue with Excel, try double-clicking the Excel file to see if Excel will open it. If Excel launches, but doesn't actually open your spreadsheet, then you are experiencing the known issue with Office 365, Excel 2016, Excel 2019, and Excel 2021. There are two ways to fix this issue:
Option 1: Launch OnePager as an Excel Add-In
This is the fastest option to get Excel to work with your old files. Try this first if you are in a jam.
- Launch Excel
- Open your Excel file by going to File > Open
- Go to Excel's Add-Ins tab, launch OnePager, and build your report.
Option 2: Repair Excel
Microsoft has fixed this issue with Excel in later builds, so as a longer-term solution, it's a good idea to repair your Excel installation to fix this and other issues you might be experiencing.
- Go into your Windows Control Panel and locate your Microsoft Office Installation. Click Modify or Repair:
- Choose the Quick Repair option and click Repair:
- Microsoft will repair your Excel installation. In about five minutes, you should be able to use Excel without this issue.
Still having trouble? If your Excel files are being generated by a third-party application such as Planisware or Salesforce, you may be experiencing a known compatibility issue between older XLS files and newer versions of Excel, for which we have a few other solutions.
Last Updated: August 18, 2021