Forum Discussion
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;...
My suggestion would be to correct the error where it originates: in Excel.
My suggestion would be to correct the error where it originates: in Excel.
really not useful. I design the report and 10 other ppl edit the excel files that I only had read access to. There must be a way to resolve this in power bi
