I have created the excel file in excel 2003 and transfered it to excel 1997 in my 2nd computer. However when i tried to save the file in excel 1997, i get the error message that some cells have more than 255 chr in them. I can still save the file, but i get that message every time i save the file. Any help in getting rid of the message?

Start Here: http://www.google.com/search?q=255+... A more specific answer would require more specific information, such as, what exactly does the cell contain....

LIR

Hi, Are you sure you're saving in an Excel 97 compatible format?

Excel 95 had a 255 character limit for any cell contents. The limit for Excel 97 was much larger, although the limit of what could be displayed in a cell was 1024 characters..

Anyway it seems likely that you have cells which contain more text than is allowed in the version you are saving to.

Obviously you can go through the cells and find those that exceed the 255 character limit, but if it is necessary to use the workbook in an earlier version, there have been suggestions for workarounds, such as saving the text in a text box. You might be able to use adjacent cells.

In your current version (Excel 2003) you could use data validation on the cells in question and limit data entry to a maximum of 255 characters, to force compatibility. (Data -Validation-Settings-Allow-Text Length and set Min/Max values to 0 and 255

Regards

Hi,

Tks 4 e reply ... the cells that excel 97 are referring to ... contained formulas which were quite lengthy because of my frequent use of nested if formulas. In excel 2003 i hv no prob, but every time i tried to save in excel 97, i get this error message. I got round the prob by 'sav as' into another temp file and then 'sav as' back to e org file. That way i don get the error message. It is v annoying esp when running a macro.

Hi, You lost me in the 'save as' and Temp files.

Why not post an example of a formula that gives the error, together with the exact error message.

For your save as workaround post the actual steps, including the version of Excel used at each step.

Finally, you say that this 'save as' workaround was successful. Do all the formulas work in Excel 97, and do all the cells with text display the same in excel 97 as they did in Excel 2003.

Regards

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History