Good news and bad news, Ralph. The bad news is that I can't duplicate your problem scenario. I've been at it for a half hour trying every different combination of Excel driver and output version. The good news is that it just works, but I do know that's not good news for you.
How many records are in the existing file, and how many are meant to be exported? Are you exporting to xls, xlsx or xlsm files?
Are the formatting and advanced features enabled? Does it work if you uncheck those options?
I'm tempted to recommend (re)installing the .Net v3 patch.
If you're still struggling with it then you might want to contact Tech Support directly. Let us know the results if you do.
Thanks Sandy for trying.
I forgot some background info. We are all running XP Pro for an O/S and are using Excel 2003. We have .Net3 installed.
As for the spreadsheet, one of them had approx 800 lines and we tried to overwrite it with approx 500 which it said was successful but wasn't.
This is all happening on a co-workers machine. I haven't been able to run it on V10 on my machine because I'm having some problems with it right now so it may just be his machine.
He is out today but I was thinking what excel output option in Monarch he is set to. I'm thinking he is set for Excel97 + Monarch V9. When I run it on V9 I have it set for Excel 97 + Monarch V8. The original file was exported out using the V8 export setting. That may be the issue.
Any how, I'll have him change his export settings tomorrow and see if that is the fix.
I have posted a message on Tech support site for my problem and am patiently waiting to hear back. I think it's an installation problem.
Thanks again Sandy.