Forum Discussion
OLE DB or ODBC error: [DataFormat.Error] Invalid cell value '#VALUE!'..
Hi Taz_Car ,
This error is thrown in Excel, where Power Query reads its data as a value (reserved word), not the formula itself.
The suggestion is to go back to the data source (excel) and replace VALUE with another meaningful name.
Related thread:
Solved: Re: "OLE DB or ODBC error: [dataformat.error] inva...Fix DataFormat.Error: Invalid cell value '#NAME?'
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
https://stackoverflow.com/a/60234320/22669679
"If you are sourcing from an Excel Spreadsheet, just after you import the data, before you even Promote Headers or Change Data types select all columns and delete errors.
That worked for me."
This worked for me too!
Perfect, worked for me as well (as per 14jan25)