I also have an Excel problem. When I open my exported summaries (there are three Excel tabs in this particular project), Excel reports that "Microsoft Office Excel cannot calculate a formula. Cell references in the formula refer to the formula's result, creating a circular reference."
The Excel sheet has not been touched by human hands (Monarch 9 created it for me) and I cannot find any circular reference.
Anybody know how to get rid of this message. This doesn't give my users a "warm fuzzy".
BTW: I love the upgraded Excel exports (except for this little querk).
For any interest party.
This problem also happened to us, Excel 2002, Monarch v 7 & 7.02.
The Fix in our case (a fluke guess on my part - if I'm totally honest).
NOTE: **Before you attempt to export the data **
1. Select Table Window
2. Select Options --> Export & Clipboard
3. Click the GENERAL Tab
4. Make Sure XLS Files is set set to "Excel 97+"
5. Press OK
Try your Excel export again.....