Advertisements

Quick tip: Prevent #DIV/0! and #VALUE! errors in Excel files

Recently I was helping a client visualize their excel data using Power BI and ran across an error in Power BI when it couldn’t deal with “#DIV/0!” as a cell value in Excel: “DataFormat.Error: Invalid cell value ‘#DIV/0!’.”  You get this error in excel whenever you have a calculated formula that is trying to divide…

Advertisements