Solved: DataFormat.Error: Invalid cell value '#NAME?'.

Anonymous · ‎04-30-2019

Hi,

I get this error when trying to identify duplicates from a column called "Full Name". There is no value there with '#NAME?' so I cannot seem to remove it too. Any suggestions are greatly appreciated.

Cheers

v-chuncz-msft · ‎05-01-2019

@Anonymous ,

You'll need to correct the source file.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎05-01-2019

@Anonymous ,

You'll need to correct the source file.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.