Forum Discussion
DataFormat.Error: Invalid cell value '#N/A'.
I'm trying to pull in a value from another table using merge. I'm getting the following error: DataFormat.Error: Invalid cell value '#N/A'. I've looked at other forums to determine what is causin...
Are you using excel as datasource? Sometime in excel in formulas you have value "#N/A" and that could be the root cause for this. You need to replace that value using query editor with "null" or space and I guess that will do it.
There is a much better solution than removing #N/A from the data source. Use Transform Data - Select the Table with the error then Right click the column header and select Replace Errors, you can then modify the erronous cells to whatever you would prefer to see in them - I use null or 0 dependant on the data held therein. NB: Only use Remove Errors if you are happy for the entire data ROW with that error in it to be removed.