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
Opening Excel workbook
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Opening Excel workbook
There is nothing you can do about that, except if you could simplify the workbook.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Opening Excel workbook
Hello Hans,
Thanks for the response.
What are the ways that we can simplify the workbook? Any tips?
Regards,
Bitten
Thanks for the response.
What are the ways that we can simplify the workbook? Any tips?
Regards,
Bitten
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Opening Excel workbook
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
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Opening Excel workbook
Thanks as always for your response.
Regards,
Bitten
Regards,
Bitten