Excel 2013 is very slow in loading large workbooks, is there a way to open just the tab I want?

Anonymous
2013-01-21T18:28:33+00:00

Excel 2013 is extremely slow in opening my large workbook. Sometimes it won't respond at all and freezes my computer.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

50 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-12-30T15:43:23+00:00

    I found the reason for my problem. I clicked CTL SHIFT END and there was 65,687 empty rows that the workbook was trying to recover every time during opening. If you go to home delete drop down delete sheet rows for every sheet in the workbook then save, it will become much faster.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-09-18T22:15:00+00:00

    That would take some detailed analysis of your code and workbook. Do you have any code that protects and unprotects the sheets? That's the most common issue that causes slowness.

    Regards,

    Anita

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-09-18T21:41:25+00:00

    Hello Anita,

    I have an issue with my workbook being extremely slow when opening and saving. I have 6 macros, a whole lot of hyperlinks, and 20 tabs. Two tabs are designed to draw information from two other tabs. One out of the 20 tabs works automatically all of the rest I have designed buttons to update specifically to avoid slow running. Any suggestions to speed things up?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-07-28T13:55:51+00:00

    @peterhoa

    Could you please tell me how did you compare the two version of Excel?

    Did you use a tool to analyze their performance against a set benchmark?

    Or could you please share the details of your finding of extensive benchmarking?

    You data could help me win my fight with the IT Team in my office and have Excel 2010 installed.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2014-06-06T12:26:56+00:00

    so at this time is my only option to downgrade to my users to Office 2010?

    Yes, upgrade back to 2010 ...

    MS has already said above that they do not plan to make any changes.

    When you do, ask for a refund on 2013 and explicitly tell MS why you are dumping 2013!

    FYI: depending on the type of volume license you have, you may already have the option of 'upgrading" back to 2010 from 2013 for free

    Volume License **Downgrade Rights**

    http://www.microsoft.com/licensing/about-licensing/briefs/downgrade-rights.aspx (2010)   Try to find the 2013 version of this document

    <snip>

    Downgrade rights are granted with all application software licenses acquired through the Volume Licensing programs.

    ....

    Downgrade rights are granted for any license enrolled in Software Assurance. 

    </snip>

    Was this answer helpful?

    0 comments