Why is Excel truncating my text to 255 characters?

  • Thread starter Thread starter Mailjust4me
  • Start date Start date
M

Mailjust4me

I created a simply spreadsheet in Excel 2007 but am saving as a 5.0/95
workbook to be sure the recipient can open it. Everything was fine until I
emailed it, and it immediately truncated every cell to contain just 255
characters! Now I can't recover the missing data and I am going out of my
mind!
 
Thats the limitation with Excel upto version 7.0. You should have saved As
'Microsoft Excel 97-Excel 2003 & 5.0.95 Workbook (*.xls)' format
 
Even 2000, 2002 and 2003 versions allows 32,767 characters (text); with 1024
characters displayed in cell..
 
Back
Top