Spreadsheet-WriteExcel - Error Messages and Mangled sheet name

Posted on Tue Apr 26 21:36:03 2005 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