#DIV!/0! error not able to remove

[kamalbandam]

Hi,

I have some of the #DIV/0! error in excel file which is residing in sharepoint which I am using as a data source. I am trying to remove those errors and replace them but none of them aren;t working. there is a step where I need to pivot columns for which I am getting the error. Any solutions will be helpful.

Thank you in Advance

[v-cazheng-msft · Accepted solution]

Hi, @kamalbandam 

You can refer What is Div/0! Error in Excel? and Quick tip: Prevent #DIV/0! And #VALUE! Errors in Excel files.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11]

Hi @kamalbandam ,

It's hard to judge why you are getting this error without seeing your data.

Which columns are you using to calculate the column which has this error?

What are the data-type of the columns?

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati

[kamalbandam]

Hi @Pragati11 

Actually, the error I am getting is this - "[DataFormat.Error] Invalid cell value '#DIV/0!'." There are some of the non divisible values which are in the source file as #DIV/0!. It is directly giving error. It is irrespective of the data type. I have tried replacing errors, removing errors but neither didn't work. How can we get rid of this value.

Thanks,
Kamal

[Pragati11]

Hi @kamalbandam ,

The error what you are referring to above is in the source column right?

Is the excel exported from someother source?

To my understanding "'#DIV/0!'" error only comes when the column is calulated using other columns and there are nulls or 0 in those columns.

Can you click on one of the cell of this column with error and check if it is calculated using some formula?

Is this data directly copied from some other place?

I can't comment further without seeing some sample data.

Thanks,

Pragati