5wprl

Fix ‘text stored as number’ green-triangle warnings in Excel. Why SUM returns wrong totals, the bulk-conversion procedure, and import-time prevention.

Fix Google Sheets ImportRange stuck on ‘Loading…’. Quota exhaustion, authorization loops, the empty-cell trick, and the IMPORTRANGE-cache mystery.

Fix #REF! errors after sorting filtered Excel data. Why sorts shift formula references, the Excel Table fix, and INDIRECT preservation patterns.

Fix HLOOKUP #N/A on approximate matches. Why your data must be sorted ascending, the boundary-value trap, and switching to XLOOKUP for sanity.

Fix #VALUE! errors in Excel CONCATENATE, TEXTJOIN, and the & operator. Date coercion failures, error propagation, and the TEXT-wrap fix.

Fix Excel conditional formatting formulas that don’t highlight. Absolute vs relative reference traps, applied-to-range mistakes, and the rule priority bug.

Fix ‘Invalid cell reference’ errors in Excel named ranges. Broken references, scope conflicts, and the audit script that finds every problematic name.

Fix #NUM! errors in Excel amortization schedules. Negative rates, sign convention traps in PMT/IPMT/PPMT, and the manual schedule that works every time.

Fix #NAME? errors caused by missing Excel add-ins. The reference dependency map, distribution strategy, and silent compile errors that look like missing functions.

Fix Excel COUNTIF counting hidden filtered rows. The SUBTOTAL alternative, AGGREGATE function trick, and visible-only counting patterns.