removing #DIV/0! errors

[solvit1421]

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 dropdown in the upper left (that selects the whole table), or the 'remove errors' function in the 'remove rows' button, or selecting all the columns and right-clicking to the get the 'remove errors' choice, the row of errors still persists. What am I missing? 

Some additional context, there was some transformations that were done too, including unpivots and combining multiple excel files. 

[Nishantjain · Accepted solution]

@solvit1421 

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

[Ashish_Mathur]

Hi,

Filter any column with errors and uncheck the box for #DIV/0!