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!