BreakerBreaker
New Member
**Excel VBA Performance Optimization – Heavy Workbook**
I have a large, complex Excel workbook (.xlsm) used for property/facilities management reporting that needs performance optimization. It works well but calculates slowly and occasionally stalls.
**What the file contains:**
- 71 sheets total
- ~10,000+ formulas including XLOOKUPs, nested IFs, and OFFSET() calls
- 27 near-identical report sheets ($1–$27) that generate dynamic narrative text from data
- Several manually triggered VBA macros
- Source data sheets feeding all calculations
**Known issues to fix:**
- OFFSET() volatile functions triggering unnecessary full recalculation (2 cells identified, may be more)
- XLOOKUP formulas referencing whole columns instead of bounded ranges (~87 instances)
- 120+ cells with 26-deep nested IF chains that should be refactored to IFS() or lookup tables
- 27 duplicate calculation sheets that could be consolidated into a parameterized template
**What I need:**
- Diagnose and fix the calculation performance issues
- Refactor volatile formulas to non-volatile equivalents
- Optimize VBA macros if they are contributing to slowness
- Preserve all existing outputs exactly — same reports, same formatting, same macro behavior
- Optionally: consolidate the 27 duplicate sheets into a single parameterized template (discuss scope separately)
**You are a good fit if you have:**
- Demonstrated experience optimizing slow or large Excel workbooks
- Strong VBA skills (not just formulas)
- Experience with dynamic text/narrative generation in Excel
- Reviews or portfolio examples showing before/after performance improvements
**Please do not apply if** your first suggestion is to rebuild this in Power BI, Python, or another platform. I need this fixed in Excel.
**Budget:** Open to discussion based on your assessment. Please include a rough hour estimate in your proposal.
**To apply:** Tell me about a specific Excel workbook you have optimized before — what was slow, what you fixed, and what the result was.
I have a large, complex Excel workbook (.xlsm) used for property/facilities management reporting that needs performance optimization. It works well but calculates slowly and occasionally stalls.
**What the file contains:**
- 71 sheets total
- ~10,000+ formulas including XLOOKUPs, nested IFs, and OFFSET() calls
- 27 near-identical report sheets ($1–$27) that generate dynamic narrative text from data
- Several manually triggered VBA macros
- Source data sheets feeding all calculations
**Known issues to fix:**
- OFFSET() volatile functions triggering unnecessary full recalculation (2 cells identified, may be more)
- XLOOKUP formulas referencing whole columns instead of bounded ranges (~87 instances)
- 120+ cells with 26-deep nested IF chains that should be refactored to IFS() or lookup tables
- 27 duplicate calculation sheets that could be consolidated into a parameterized template
**What I need:**
- Diagnose and fix the calculation performance issues
- Refactor volatile formulas to non-volatile equivalents
- Optimize VBA macros if they are contributing to slowness
- Preserve all existing outputs exactly — same reports, same formatting, same macro behavior
- Optionally: consolidate the 27 duplicate sheets into a single parameterized template (discuss scope separately)
**You are a good fit if you have:**
- Demonstrated experience optimizing slow or large Excel workbooks
- Strong VBA skills (not just formulas)
- Experience with dynamic text/narrative generation in Excel
- Reviews or portfolio examples showing before/after performance improvements
**Please do not apply if** your first suggestion is to rebuild this in Power BI, Python, or another platform. I need this fixed in Excel.
**Budget:** Open to discussion based on your assessment. Please include a rough hour estimate in your proposal.
**To apply:** Tell me about a specific Excel workbook you have optimized before — what was slow, what you fixed, and what the result was.