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.

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, Anonymous 

Glad to hear that you have worked it out.

Best Regards,
Community Support Team _ Eason