Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

#VALUE! and #REF! errors

I am using Excel spreadsheet as a source of data and I am running into issues with the #VALUE! and #REF! values. This spreadsheet contains some rows with invalid value and reference from excel so whe...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I used Table.ReplaceErrorValues and that seems to do the job.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I used Table.ReplaceErrorValues and that seems to do the job.