LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.links
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate Range Names by worksheet FlaAl Excel Discussion (Misc queries) 0 May 24th 06 05:14 PM
The filter didn't show all (2,254) names when I set it up Darrell Excel Discussion (Misc queries) 2 December 17th 05 04:25 PM
Convert Local Names to Global Names Ed Excel Worksheet Functions 1 November 30th 05 05:23 PM
Invalid Range Names Old Music Lover Excel Discussion (Misc queries) 4 July 23rd 05 01:53 AM
sorting names alphabetically when names may start with numbers John Smith Excel Discussion (Misc queries) 3 May 11th 05 08:06 PM


All times are GMT +1. The time now is 05:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"