Precision Solutions for Excel, Access, and VBA.
When a UDF looks up data from an Access table, Excel can end up calling the function hundreds or even thousands of times during recalculation. Without a cache, each call hits the database (a.k.a. server trips), opening connections, running queries, and slowing things down unnecessarily. By loading the product table into a VBA Dictionary the […]
IntroductionUsing Access as a backend transforms Excel from a bloated storage container into a fast, lightweight calculation and reporting tool. Over time, even the cleanest spreadsheets suffer from workbook creep—the slow, steady expansion of data, formulas, and hidden “temporary fixes” that turn a perfectly good model built two years ago into today’s slow, oversized, and […]
Spreadsheet Bloat: Spreadsheet Bloat: Why Your Excel Workbook Is Slow Spreadsheet bloat occurs when an Excel workbook becomes unnecessarily large, slow, or resource-heavy due to inefficient design, excessive formatting, or formulas applied far beyond the real data range. It doesn’t mean your file is broken, but it often leads to sluggish performance, long recalculation times, and […]
Dynamic Gantt Charts In this video, I demonstrate how to create a dynamic Gantt Chart in Excel using VBA, including annotated “Event” diamonds to highlight key moments, like delays due to vandalism or bad weather. You’ll learn how to: Use VBA to create and add shapes (rectangles and diamonds) for chart visualization. Add event-specific code […]
In today’s fast-paced, data-driven world, businesses of all sizes rely on spreadsheets for everything from daily tasks to business-critical operations. However, despite their importance, many overlook the risk of losing these invaluable files due to corruption or human error. That’s where the Free Excel Backup Tool comes in. This tool is designed to protect your […]