Set up automatic recalculation — AI Prompts for Google Sheets

3 ready prompts

Written for the moment this actually comes up.

Execute — do the immediate task

Set the workbook to recalculate automatically for iterative changes. Turn on recalculation so that…

Set the workbook to recalculate automatically for iterative changes. Turn on recalculation so that formulas update on change and every minute, and enable iterative calculation with a maximum of 50 iterations and a 0.001 convergence threshold to allow the cash-flow circular reference to converge. Confirm that volatile functions like RAND and NOW update on that schedule and report any formulas that now risk slow performance.

Decide — diagnose the stuck moment

After I copied an auxiliary sheet into the model, the whole workbook started lagging and…

sheets slowed to a crawl after a change

After I copied an auxiliary sheet into the model, the whole workbook started lagging and recalculation spikes CPU. I’m worried I’ve introduced many volatile formulas or accidental circular references. I can list the recent sheet copy and the cells I edited. What’s the likely cause and the fastest diagnostic steps to restore interactive performance without losing recent edits?

Become — change the pattern

Every time an analyst copies a template or adds a scenario sheet, the file becomes sluggish because…

we keep getting slow workbooks from feature copies

Every time an analyst copies a template or adds a scenario sheet, the file becomes sluggish because someone sprinkles volatile formulas and circular math. I’m the ops lead with many contributors. Which concrete rules, review checklist, and editor habits should I enforce so models stay responsive while still allowing iterative calculations where truly needed?

Next to this one

Other spreadsheet work people do in Google Sheets.

Resize rows and columns Resolve collaborator comments Resolve conflicting edits Schedule email notifications Set editing and view permissions Share spreadsheet with colleagues Sort data by column Split text into columns Summarize data with formulas Track attendance or grades

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.

The rest of the map

Same library, five ways in.

Work Atlasthe whole map, interactive Careers1,949 jobs and their real tasks Soft skillsthe human part of the work Activities500 things people do Prompt Librarybrowse every prompt