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

Anonymous

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

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

Anonymous

2013-02-04T16:26:00+00:00
Hello Peter,

Can you tell me a little more about what is in the workbook you benchmarked, and how you opened it?
1. First of all, are you opening locally or over a network?
2. How large is the book?
3. How many formulas are in it, and does it make a difference if you set calc to manual before you open the book?
4. Does it have external data ranges that are set to refresh on open?
I'll try to test myself, but it would really help to know where to start.

Thanks,

Anita Oakley
Was this answer helpful?

0 comments No comments
Anonymous

2013-02-02T12:01:32+00:00

I have benchmarked file opening extensively, comparing Excel 2010 with Excel 2013. Excel 2013 takes roughly twice as long to open XLS and XLSM workbooks. eg a workbook that takes 7 seconds with Excel 1010 takes 13 seconds with 2013. This is massively slower.

What is the solution?
Was this answer helpful?

0 comments No comments
Anonymous

2013-01-31T16:23:36+00:00

I have exactly the same problem: large workbook opens very slowly in Excel 2013.

How to solve this issue?

Thanks

Jacques
Was this answer helpful?

60+ people found this answer helpful.

0 comments No comments
Anonymous

2013-01-21T21:38:10+00:00

So does anyone know a way to open it faster? Or better?
Was this answer helpful?

10+ people found this answer helpful.

0 comments No comments
Anonymous

2013-01-21T19:45:09+00:00

Hi, sorry but you cannot open only one tab from a workbook
Was this answer helpful?

0 comments No comments