Forum Discussion

MikeO's avatar
MikeO
Helper I
9 years ago
Solved

"OLE DB or ODBC error: [dataformat.error] invalid cell value '#NAME?'

I have connected to a single table in excel and whenever I try to close and save the query editor, I get the above message.  In reviewing the table in query editor I see the bottom row is all errors;...
Need Help
Tutorial Requests
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    My suggestion would be to correct the error where it originates: in Excel.

djankuna's avatar
djankuna
Frequent Visitor
4 years ago

Hi! 

Same issue from our side. I am trying to refresh Power BI (updated excel sheet uploaded), it says:

OLE DB or ODBC error: [DataFormat.Error] Invalid cell value '#NAME?'...

 

But I cannot track this mistake in my excel sheet, nor check this in Power BI query edditor (because the excel is not uploading/refreshing - old format data is 'standing'). 

 

any suggestions here? 

cpolex's avatar
cpolex
Regular Visitor
4 years ago

Facing same issues here.  It happens when i try to expand the table after merge query. Everything works well before that.. even after an append query.

Tried replacing error with values and removing empty rows etc but does not solve the issue.

 

Appreciate any guidance to troubleshoot the issue and hopefully fixing it at power query