Linked to Excel table - blank cells are #NUM!

B

bejewell

Hi there...

I am working with a master worksheet in a large Excel workbook. The master
worksheet includes several formulas and links to other worksheets in the
workbook.

My DB links to this master worksheet, but when I open the table in Access,
there are lots of #NUM! errors appearing in the cells that appear as blank in
my Excel spreadsheet. Is there any way to set this up so that these cells
show as blank just as they do in Excel?

Any suggestions are greatly appreciated...

Thanks!
 
Top