Forum Discussion
OLE DB or ODBC:[DataFormat.Error] cell value #REF invalid
Hi TheoC
Thanks for your kind answer, it was simpler than we thought, but still I leave it here in case anyone finds it useful: if you Ctrl+F or (Ctrl+B) in some places, and search for #REF excel will not find those values. You have to go to Find and select, then go to special and enable errors.
Rookie mistake but what can you do.
Thanks again!
Anonymous
In Power Query, can you go to the respective query, go to the most recent / last Applied Step (far right pane). Keep a look out for an error notification at the base of Power Query and start to click on each step in the Applied Steps section as you go back to the first one being "Source".
If the issue is not identify, then check the Source file and ensure you have no changed the Name, File Location, File Type (i.e. CSV, XLS, XLSX, XLSB, XLSM, etc), Field / Column Headers, etc.
If the above doesn't identify the issue, check the Excel file and ensure that no changes to Data Types in the file itself have been made.
Finally, if the above doesn't identify the issue, recreate your Excel file and save it does as a new XLSX. Adjuste the "Source" step in your "Applied Steps" to ensure it links to the new file.
This should resolve the problem. If not, I have nothing else unfortunately! 😞
Hi TheoC
Thanks for your kind answer, it was simpler than we thought, but still I leave it here in case anyone finds it useful: if you Ctrl+F or (Ctrl+B) in some places, and search for #REF excel will not find those values. You have to go to Find and select, then go to special and enable errors.
Rookie mistake but what can you do.
Thanks again!