Hi all,

I am using the docmd.outputto function to output a report to microsoft excel.

The entire process goes on fine until when the excel file opens, i get this error message in excel:

"File error: data may have been lost"
Then, the cell which are supposed to display the "sum" shows #N/A

This problem will not occur if i output the file to a RTF.
The "sum" fields also displays properly.

Anyone know why?

Thanks in advance!

Scripts82

__________________
Scripts82