Link from Access to Excell produces "#Num!"...How do I get rid of it?

[BFP]

Hi All.

I have linked a table in Access (2003) to an Excel spreadsheet.

Sometimes, I get #Num! in some of the cells in my Access table, which causes queries to fail.

What is the best permenant solution for this (as I will be updaing the Excell Spreadsheet)?

Thanks,

BFP

 

[Remou]

Hi
This might help:
#Num!
thread181-1078738