Opening Excel workbook

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Opening Excel workbook

Post by BittenApple »

Hello team,

I have an Excel workbook that contains array formulas and dropdowns. When I want to open, it load till some percentage, say 58 percent, then there is a halt and then after a couple second, all opens.

Can we improve this behavior of Excel?

Regards,
Bita

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Opening Excel workbook

Post by HansV »

There is nothing you can do about that, except if you could simplify the workbook.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Opening Excel workbook

Post by BittenApple »

Hello Hans,
Thanks for the response.
What are the ways that we can simplify the workbook? Any tips?
Regards,
Bitten

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Opening Excel workbook

Post by HansV »

You can often simplify complicated formulas by using a helper column (or row). The exact implementation depends on the formulas and the structure of the worksheets.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: Opening Excel workbook

Post by BittenApple »

Thanks as always for your response.
Regards,
Bitten