Workbook Performance and File Size Audit
Find what makes a spreadsheet slow.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Audit a slow workbook. File size, number of sheets, rows, formulas types, volatile functions, conditional formats and lookups: [WORKBOOK_STATS]. Where the slowness appears: [SLOWNESS]. Software and computer: [SOFTWARE_COMPUTER]. Identify likely causes: whole-column references, volatile functions, redundant lookups, huge used ranges, excessive formatting, images, unused styles and data kept for convenience. Rank fixes by effect and risk, and explain how to measure before and after. Return a table with Cause, Evidence, Expected gain and Risk, a score from 1 to 10 for efficiency, and a safe clean-up procedure with a backup. Also suggest splitting archive data into a separate file, turning calculation to manual only with a visible warning, and recording the open time before and after each change. Include a note on keeping a backup before deleting any sheets or ranges. Further, suggest a simple benchmark, such as time to open and time to recalculate after changing one input, and a table to record results after each fix. Suggest which fixes to try first on a copy, and how to confirm that no values changed after clean-up by comparing key totals.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.