Forum Discussion
Solved
removing #DIV/0! errors
Hi, I have a row of 'error' as values across all columns in my query editor page. It corresponds to a #DIV/0! error from a source .xlsx. Despite trying the 'remove errors' function in the dropdow...
The "Remove Error" function in Power Query cannot remove errors generated in Excel. Youl will have to remove the #DIV/0 in Excel before importing
The "Remove Error" function in Power Query cannot remove errors generated in Excel. Youl will have to remove the #DIV/0 in Excel before importing