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
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 Team
If 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