Posted on 2005-04-26 18:36:03-07 by marfolarfo
Error Messages and Mangled sheet name
I am generating a spreadsheet with 4 data sheets and 4 chart sheets. When first creating a new excel xls file, I encounter the following error message 4 times when opening the spreadsheet. "File error: data may have been lost." The spreeadsheet looks OK once it is open except that the name of the first sheet generated is mangled. For instance, instead of being "download" it is, "#@$#awnload." At this point the only way I can change the name is to save the spreadsheet and exit excel. It will core dump with some nasty message when you do this. Then open the spreadsheet again. This time the error messages will not present and, once up, I can change the name of the managled sheet by right clicking on it and using the rename capability of excel.
Direct Responses: 389 | 390 | Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.