Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

OLE DB or ODBC:[DataFormat.Error] cell value #REF invalid

Hi thank you for reading,   I've been using this model for 6 months now but suddenly I get this error.   My datasource is an Excel file, so logically I looked thoroughly for any #REF errors but f...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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!

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Thank you I was very useful your contribution.