Invalid cell value '#NAME?'

[MikeO]

I am connected to a single table in a Microsoft Excel sheet and I am receiving the following error after PowerBI attempts to apply query changes: [DataFormat.Error] Invalid cell value '#NAME?'

If I go into Edit Queries and Remove Errors, the whole table goes away and the same DataFormat.Error pops up until I delete that step.

[v-chuncz-msft · Accepted solution]

@MikeO,

It seems that you have already solved this problem here. Any further question, feel free to raise a new thread.

[Anonymous]

It doesn't seem like he found the solution. There is no solution posted or accepted. This forum needs to get better at actually solving problems, rather than attempting to pass the buck. People search the forums for similar issues and find many posts like this, where the moderators consider silence from the original poster as a solution. 

[DataShepard]

Yeah, even several years later these forums suck.  And Microsft has a team of full time staff monitoring these forums!

[MikeO]

I am connected to a single table in a Microsoft Excel sheet and I am receiving the following error after PowerBI attempts to apply query changes: [DataFormat.Error] Invalid cell value '#NAME?'

If I go into Edit Queries and Remove Errors, the whole table goes away and the same DataFormat.Error pops up until I delete that step.