Excel Link #NUM! Error

[darreno]

I am trying to link Access to an Excel sheet on the server and I only have Read access to the Excel file. When I open up the linked table, there are some #NUM! errors on a column with dates formatted as 6/1-6/30. Single dates like 6/1/08 have no errors. How can I solve this?
Thanks.

 

[doco]

I am trying to link Access to an Excel sheet on the server and I only have Read access to the Excel file. When I open up the linked table, there are some #NUM! errors on a column with dates formatted as 6/1-6/30. Single dates like 6/1/08 have no errors. How can I solve this?
Thanks.

Apparently Excel believes you are saying ( 6 / 1 ) - ( 6 / 30 ): in other words a formula instead of a date. You cannot enter multiple dates in a single field formated as date.

 

[darreno]

If I import it, the data is fine. Its the linking that troubling. Assuming no changes made to the Excel file, is there a way to solve this error?

 

[ajetrumpet]

I think you're stuck, Darren. The change has to be made to the source file, weather that change be a data type one, or a formatting change.

 

[darreno]

Stucko is not good...
Thanks guys.