Troubleshooting

Spreadsheet Formula Troubleshooting

Fix formula errors, wrong results, lookup problems, date issues, and DAX reporting problems.

💡 Ideas for You

Helpful resources matched to this page.

4 focused options

📚 Step-by-step booksIndependent learning resources and step-by-step books from Create & Learn.📘 Topic guideAmazon ideas related to spreadsheet troubleshooting.🧮 Formula booksBooks and references for spreadsheet formulas and examples.⌨️ Productivity setupHelpful books, office tools, and productivity resources.

Troubleshooting library

Fix formula errors, lookup problems, date issues, calculation problems, and Power BI DAX reporting issues.

Excel formula not calculating

Likely causes, checks, and fixes.

Excel showing formula instead of result

Likely causes, checks, and fixes.

Excel copied formula gives wrong result

Likely causes, checks, and fixes.

VLOOKUP not working

Likely causes, checks, and fixes.

XLOOKUP not working

Likely causes, checks, and fixes.

INDEX MATCH not working

Likely causes, checks, and fixes.

COUNTIF not working

Likely causes, checks, and fixes.

SUMIFS not working

Likely causes, checks, and fixes.

Date formula not working

Likely causes, checks, and fixes.

Percentage formula wrong

Likely causes, checks, and fixes.

Excel #N/A error

Likely causes, checks, and fixes.

Excel #VALUE error

Likely causes, checks, and fixes.

Excel #REF error

Likely causes, checks, and fixes.

Excel #DIV/0 error

Likely causes, checks, and fixes.

Excel #SPILL error

Likely causes, checks, and fixes.

Excel #NAME error

Likely causes, checks, and fixes.

Excel circular reference warning

Likely causes, checks, and fixes.

Excel links not updating

Likely causes, checks, and fixes.

Excel formulas slow workbook

Likely causes, checks, and fixes.

Excel numbers stored as text

Likely causes, checks, and fixes.

Excel leading zeros disappearing

Likely causes, checks, and fixes.

Excel dropdown not showing

Likely causes, checks, and fixes.

Excel filter not including all rows

Likely causes, checks, and fixes.

Excel pivot table not refreshing

Likely causes, checks, and fixes.

Excel chart not updating

Likely causes, checks, and fixes.

Excel conditional formatting not applying

Likely causes, checks, and fixes.

Excel formula returns blank

Likely causes, checks, and fixes.

Excel formula returns zero

Likely causes, checks, and fixes.

Excel date shows serial number

Likely causes, checks, and fixes.

Excel ##### error

Likely causes, checks, and fixes.

Excel file opens read-only

Likely causes, checks, and fixes.

Power BI DAX measure returns blank

Likely causes, checks, and fixes.

Power BI total row wrong

Likely causes, checks, and fixes.

Power BI relationship not working

Likely causes, checks, and fixes.

Power BI date table problem

Likely causes, checks, and fixes.

Power BI many-to-many issue

Likely causes, checks, and fixes.

DAX CALCULATE not filtering

Likely causes, checks, and fixes.

DAX DISTINCTCOUNT wrong

Likely causes, checks, and fixes.

DAX time intelligence not working

Likely causes, checks, and fixes.

Excel import to Power BI wrong types

Likely causes, checks, and fixes.