Thread: Invalid Names
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
Bill Manville Bill Manville is offline
external usenet poster
 
Posts: 473
Default Invalid Names

Unfortunately those names indicate a corrupted workbook.
If you have a recent backup without those corrupt names I would go back
to it.

Otherwise you could try saving as HTML format and editing the HTML to
turn the corrupted names into alphabetic characters and then re-opening
and saving as XLS. Be sure to keep a backup copy; you will lose some
features in round-tripping to HTML, depending on which version of Excel
you have [it always helps if you tell us]

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup