View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vbfoxdev35 vbfoxdev35 is offline
external usenet poster
 
Posts: 1
Default 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