Exporting into Excel 5-7 format???

[Tommy B]

Hi Guys,

Hope you are all well! Here's a funny glitch I have noticed with Access 2k. I have just convereted my '97 database to 2k and when I export an access report into Excel 5-7 format the calculated cells are lost!? The subtotalled breakdown appears as normal...but as I said...no totals?

Can anyone shed any light on this?

Cheers,

Tommy B.