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!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Glad that your problem is solved, thank you for sharing. Would you mind marking the correct answer as solution, so that other users with similar problems to yours can find it more quickly.Thank you very much for your kind cooperation!

 

Hope it helps,


Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.