Speed Up Excel workbook

[yonibrese]

Hello,

I have a massive excel workbook, with over 20 worksheets and many macros running in the background.
But, The size of my workbook is starting impact the speed of my project.
are there any tips that I can do to increase the speed of the workbook?

Thanks in advance.

[AliGW]

Administrative Note:

Welcome to the forum.

Is your forum profile showing the oldest Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

[AliGW]

What else is in the workbook? Formulae? If so, using full column references? Volatile functions? Any conditional formatting?

How big is 'big'? How slow is 'slow'?

How large are the worksheets (rows x columns)?

What is the nature of the macros?

We can only guess without this sort of detail.

[TMS]

In the absence of any detail, or a sample workbook, and to avoid re-inventing the wheel, here are some links:

https://learn.microsoft.com/en-us/of...e-obstructions
https://trumpexcel.com/suffering-fro...-spreadsheets/
https://www.howtogeek.com/ways-to-sp...-spreadsheets/
https://professor-excel.com/15-ways-to-speed-up-excel/

And, for more suggestions, Google: speed up excel spreadsheet