Truncated string in a *.mht file

[BajanPOET]

I've added some code to a button in Excel to save the spreadsheet as a *.mht file. The file is a purchase order, with three sections: the second and third sections are duplications of the first (Duplicate and Triplicate sections). All of the cells in the last two sections have IF statements in their formulas as such

IF(E24="","",E24)

so that if the cell that it is linked to is empty it stores an empty string, else it copies the value of the cell into the current one.

The problem I have is that when I double click the file that was created to see the file in the browser, one particular field in the first section (Original) is truncated, even although the corresponding fields in the Duplicate and Triplicate sections show the entire string. If I open the *.mht file using Excel the entire string that appears to be truncated is seen in its entirety.

Is there a way to attach a file so that you guys can see what I'm talking about?

What? Who? ME????

 

[AlexCuse]

No way to attach the file, unless you have it on the web and can post a link.

What is the particular string being truncated?

A wise man once said
"The only thing normal about database guys is their tables".

 

[BajanPOET]

It's just a line of text. I created an external query that pulls the Supplier name out of my Access dbase and displays it on the Excel spreadsheet. It shows in its entirety there - and the duplicate and triplicate on the *.xls file are there as well. It's only when I save it as a *.mht file and open it in the browser that the original line of text seems truncated.

What? Who? ME????

 

[BajanPOET]

Barring that...

I was creating the *.mht file because my boss wanted a way to prevent changes of the purchase order after she had saved it. Is there a better way of doing this rather than trying to create Web Archive files?

What? Who? ME????