Excel 2003 Save as Bug
All:
Has anyone run into this situation. I create data upload files and for
some instances have cells that have about 1500-2000 characters
(outputed memo records from a foxpro database). These files are then
imported by my clients into their systems.
The problem that I recently came across is when the data is written to
the cell, it is all there when I view the sheet. When I save in Excel
2003, close and then re-open the spreadsheet, the cell(s) with the
large data (say cell C13) is duplicated and overwrites the data in
another cell 2 rows down (say cell C15).
If I do this same procedure in Excel 2000 or XP, it is fine.
Has anyone else come across this, or might know what I need to look
at.
I came up with a small fix. WHen I write the large data I enclose the
data with Full quotes and then when I save I am ok when I re-open the
spreadsheet.
I have heard about the old Alt-Tab when writing data to excel, but
this should not matter if I use a 2000/XP excel client and it works
fine.
What did Uncle Bill change in 2003 excel I wonder.
Thanks for any help or thoughts.
If I could post screenshots I would to show you all what I am talking
about.
Thanks
Art
|