ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003 Save as Bug (https://www.excelbanter.com/excel-programming/303592-excel-2003-save-bug.html)

vbfoxdev35

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


All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com