Hi guys I was going through Microsoft visual basic documentation to keep up to date in Access and Excel and got to this page, which may help a few people who have spreadsheets and workbooks with multiple cell calculations running slowly. The latter half of the page hones in on improving calculation performance
https://learn.microsoft.com/en-us/offic ... erformance
Speeding up Excel
Interesting. My worksheet, which started off taking 8 minutes to calculate, ended up within a year running all night and still not being finished!
I don't use VBA, but discovered recently that conditional formatting, which I use loads, was slowing down general navigation around my worksheet.
I don't use VBA, but discovered recently that conditional formatting, which I use loads, was slowing down general navigation around my worksheet.