Refresh external data connections

Refresh external data connections in Microsoft Excel — with the four heights of help laid out: do it now, make it easier for the next person to accept, work out the right move when you are stuck, and learn the pattern so it stops coming back.

4prompt heights
Open it in the interactive atlas →

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

+
The quarterly model needs the latest feeds before the 9am review. Refresh the external data…
The quarterly model needs the latest feeds before the 9am review. Refresh the external data connections, confirm each query completed without errors, and save the workbook versioned as Q3-Refresh-1. If any connection fails, capture the exact error text and stop; do not overwrite the previous file.

Improve — make it easier to accept

+
Before I refresh for the review, make it safe for people to rerun. Surface which queries pull from…
Before I refresh for the review, make it safe for people to rerun. Surface which queries pull from live systems, show last-refresh timestamps, flag queries that take longer than 30 seconds, and list any transformations that could change column types. Highlight likely causes of failures so the reviewer can approve the refresh confidently.

Decide — diagnose the stuck moment

+
I refreshed the workbook and the payroll feed failed with a timeout. Payroll is owned by Amanda in…

I started the refresh and one connection failed.

I refreshed the workbook and the payroll feed failed with a timeout. Payroll is owned by Amanda in ops; finance needs the updated numbers by 9am. I cannot tell whether the timeout is transient or a changed endpoint. What is the most likely cause and the quickest next move so we meet the review deadline?

Become — change the pattern

+
Every report-cycle I spend an hour fixing failing external connections and replaying refreshes.…

Refreshes frequently break and cost time before reviews.

Every report-cycle I spend an hour fixing failing external connections and replaying refreshes. Where are we losing time or control — permissions, unstable endpoints, or undocumented queries — and what single habit should I change so refreshes succeed first time?

Next to this one

Other spreadsheet work people do in Microsoft Excel.

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.
Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.

The rest of the map

Same library, five ways in.