5wprl

Fix permanent #GETTING_DATA states in Excel & Sheets. RTD server stalls, circular calc dependency, and the cache-clear procedure most guides skip.

Track down and fix circular references in complex Excel budgets. The trace-precedents method, iterative calculation use cases, and the hidden status bar tell.

Fix Google Sheets QUERY returning empty #N/A. Header row mismatches, data type collisions, label syntax, and the case-sensitivity rule no one documents.

Fix Excel #VALUE! when mixing text and numbers. The TEXT, VALUE, and concatenation traps — plus the regex extraction pattern for messy mixed cells.

Fix #REF! errors caused by Google Sheets protected ranges. Permission boundary collisions, IMPORTRANGE auth, and the audit checklist before sharing externally.

Fix XLOOKUP returning #N/A for partial matches in Excel. Wildcard mode argument, fuzzy matching strategies, and the case-sensitivity workaround.

Fix INDIRECT #VALUE! errors in Excel. Closed-workbook restriction, sheet name quoting, and the OFFSET fallback that preserves dynamic references.

Fix Excel #NUM! errors in POWER, EXP, and exponential formulas. Excel’s 1.79E+308 ceiling, the LN scaling workaround, and double-precision overflow.

Fix #NAME? errors when porting files between Excel and Google Sheets. Function name differences, _xlfn prefixes, and the compatibility map you need.

Fix #REF! errors in Excel pivot table data sources. Range expansion, table conversion, named-range fallback, and the data model refresh trick that recovers them.