export into excel from access error

  • Thread starter Thread starter Panos
  • Start date Start date
P

Panos

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 Acces
File/SaveAs ..Export
 
Back
Top