export into excel from access error

Hi,

I've got an access application which produces a report,
then the report outputs into excel. The excel application
opens automatically when you run the access report.

However, whilst the report is being produced Excel
generates an error message saying that "can't expand named
range" and fails to produce the report. It works fine if
there are no rows in the query, ie it automatically opens
the excel spreadhseet and populates the header. It also
works fine for other users, so it has to be some
enviromental issue with Excel?

Thanks very much in advance,

Panos

I get this fairly frequently. It seems to be some sort of "corruption"
in the Excel .xls file. I solve it by remaking the file using Access
File/SaveAs ..Export.


---
Message posted from http://www.ExcelForum.com/