{"id":18541,"date":"2018-05-16T10:42:47","date_gmt":"2018-05-16T10:42:47","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=18541"},"modified":"2023-06-01T17:40:02","modified_gmt":"2023-06-01T17:40:02","slug":"excel-stuck-at-opening-file","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/excel-stuck-at-opening-file\/","title":{"rendered":"Excel Stuck at Opening File 0% – Resolve Performance Issues"},"content":{"rendered":"

When you open an Excel file (XLS\/XLSX) in MS Excel, the program reads and then loads the file data along with all its objects and properties. While opening and loading an Excel file, MS Excel displays an “Opening percentage<\/em>.” You won’t usually notice or see this Excel file opening progress percentage while accessing smaller worksheets.<\/p>

It’s more noticeable when you open a large Excel file or workbook with multiple objects, formulae, formatting, etc. However, after opening an Excel file with double-click, if it is stuck at Splash Screen<\/em> with a message “Opening: FileName.xlsx (0%)”<\/strong> for a while (say 15-30 minutes) and does not progress, it indicates a problem with the Excel file, MS Excel program, or the system.  <\/p>

\n
\"excel<\/figure>\n<\/div>

Why Excel is Stuck at Opening File 0%?<\/h2>

If you have encountered this error, it may happen due to one of the following issues,<\/p>

    \n
  1. Damaged or corrupt Excel file<\/li>\n\n\n\n
  2. Incompatible or faulty Excel add-ins<\/li>\n\n\n\n
  3. Problem with the system’s display driver<\/li>\n\n\n\n
  4. Damaged MS Office (Excel) application<\/li>\n<\/ol>

    Methods to Fix ‘Excel Stuck at Opening File 0%’ Issue<\/h2>

    Before fixing and troubleshooting the problem, check and confirm if the Excel file is working and not corrupt. For this, you can try opening it on another PC. Now there could be two scenarios,<\/p>

    Scenario 1:  Excel File Does Not Open<\/strong><\/h3>

    If the Excel file doesn’t open on another PC also, it indicates Excel file corruption. In such cases, look for the backup copy of the file, if you have downloaded it from an email or a website.<\/p>

    However, if there’s no backup, then you need an Excel file repair software, such as Stellar Repair for Excel<\/strong> to repair the corrupt file. This software preserves Excel file properties, such as cell formatting, formula bar, freeze panes, gridlines, etc. and helps you restore the damaged or corrupt worksheets to its original state with 100% integrity.<\/p>

    \n
    \"free<\/a><\/figure>\n<\/div>

    To repair Excel file, download and launch Stellar Repair for Excel<\/em> software on your PC, choose the corrupt Excel (XLS\/XLSX) file and click ‘Repair’<\/strong>. You can see the preview of your Excel file with all data and then save the repaired file at your desired location on the system as a new Excel file.<\/p>

    \n
    \"stellar<\/figure>\n<\/div>

    Scenario 2: Excel File Is Accessible on Another PC<\/strong><\/h3>

    If the Excel file opens successfully on another PC, then follow the troubleshooting methods below to resolve the Excel file stuck opening at 0%.<\/p>

    Method 1: Open MS Excel in Safe Mode<\/strong><\/h2>

    To check if an incompatible or faulty add-in or setting is causing the error, restart MS Excel in safe mode and then open the worksheet from the MS Excel ‘File<\/strong>’ options. The steps are as follows,<\/p>

      \n
    1. Press Windows+R<\/strong> and type excel.exe \/safe<\/strong><\/strong><\/li>\n\n\n\n
    2. Hit Enter<\/strong> or press ‘OK<\/strong>’ to open MS Excel in safe mode<\/li>\n<\/ol>
      \n
      \"open<\/figure>\n<\/div>