Forum Discussion

kamalbandam's avatar
kamalbandam
Helper III
5 years ago
Solved

#DIV!/0! error not able to remove

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

Need Help

4 Replies

    • kamalbandam's avatar
      kamalbandam
      Helper III
      5 years ago

      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's avatar
        Pragati11
        Super User
        5 years ago

        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