When I first reported this issue about a year ago, most people acted like it
did not actually exist. But now I see others have had the same problem. I
never did get a solution to this problem. The application I developed I had
to create a printout of all named ranges and where they most like occurred so
that the people who were left with this mess could, HOPEFULLY, recreate the
named ranges when they need to due to this bug! What a drag!

"Chrisp" wrote:

Did anyone ever resolve this problem. We are experiencing it today. The
files have been used for years, converted to 2007 format in September using
Convert feature. Slight problem at conversion with range names, which was
corrected and the file was fine until today when range names started
disappearing.

These range names are used in macros for printing ranges.

I really appreciate any new info anyone might have on this problem.

"Bernie" wrote:

I expierenced the same problems with the named ranges. I did not convert the
workbook from an earlier version. So I think this is not the problem.

The strange thing I notice is that even when I add the named range again,
saving the document, reopening it: the named range has disappeared again.
Sometimes it helps to quit windows, start it again, open the workbook and add
the bookmarks manually.

I agree with Mike that it are most of the time the same named ranges that
disappear. I really do not have an idea what's causing it. I am know thinking
about it, to install Excel 2003. Maybe this issue is only related to 2007. I
did never expierenced this kind of problems with earlier versions.

If anyone has a suggestion. Please let me know because it really makes me
crazy !@#$%

"Bruce Chan" wrote:

Did you ever resolve this problem? I'm experiencing the same problem with Excel 2007. I'm using names with no special characters like 'RollupTable' and 'CapExTable'. The names will w/o warning disappear from time to time, and then I have to re-define them.

These files were created in the previous version and saved to 2007. I wonder if that had anything to do with this.