Category: Workbook performance

I don’t often re-post, but hard not to with this really good post on Excel VBA speed and efficiency  Well worth the read. https://www.soa.org/news-and-publications/newsletters/compact/2012/january/com-2012-iss42/excel-vba-speed-and-efficiency/

Tagged with: ,

In my recent post of Fix duplicated Conditional Formatting Rules , I mentioned you should be careful using Conditional Formatting in situations where you have thousands of rows of data or calculations as this can be a drain on performance.  …

Alternatives to Conditional Formatting Read More »

Tagged with: , , , , , , ,

This post is about monitoring the workbook environment when working on key workbooks or workbook applications especially if they involve VBA, which is my approach to developing key workbooks for clients.  You wouldn’t do this for an ad hoc or …

Monitoring the Workbook Environment Read More »

Tagged with: , , , , , , , , ,