Named Ranges Disappear In Excel 2007

[Mike H.]

I have a problem in Excel 2007. Named ranges disappear from time to time.
It appears the same names will disappear. I re-add them and everything is
fine for a while, then they are gone. It is not a scope problem.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...5b7c737&dg=microsoft.public.excel.programming

 

[Charlie]

They are probably local ("sheet level") names. Click on each sheet then
click the names drop-down til you find them. Named ranges local to a
specific sheet will not be visible from other sheets.

 

[Mike H.]

No that is not the problem. They "evaporate". I did a search on this site
and found others who have had the same problem but nobody has gotten an
answer yet!

 

[Charlie]

Weird. I'll keep my eyes open as I use named ranges all the time.

 

[Jon Peltier]

Mike -

Could you post these links? I don't recall coming across this issue before.

- Jon

 

[Bruce Chan]

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.

 

[Steve S]

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.

10/1/08 - I have just encountered the same problem. We would run a macro
and it would crash because a named range had disappeared. We stopped the
macro, went in and added the name, but when we started the macro again,,
another name had disappeared. Can this be caused by the way the files are
compressed and decompressed every time you save it?

 

[Bernie]

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 !@#$%

 

[Chrisp]

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.

 

[Mike H.]

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]

I have been getting info from another Excel forum that there may be a patch
in April that will resolve this problem and others like it. You can read the
thread:

http://excelusergroup.org/forums/p/1208/3786.aspx#3786

I hope this is true.

 

[Trefor]

I have update from Office 2003 to 2007 and now I am having this issues as well.

My code creates a new file in Office 2007, then copies a sheet from the 2003
upgraded file to the new file. So technically the file is new, but the sheet
had been upgraded from a 2003 file. Without reason and without warning I note
2 named ranges get removed (there maybe more, but I have only stumbled on
these 2). The named range is for a single cell and contains a formula.

This happens more often than not when I create the new file, but its always
the same to named ranges.

I have upgrade to SP2 and applied every available fix/patch including the
hot fix (KB968863) and it still broken.

Does anyone have any suggestions?

 

[invisionz]

I am going nuts! I have designed spreadsheets in Excel 2003 and never had
this problem before. Now in Excel 2007 I have discovered this problem after
spending many, many hours designing an elaborate spreadsheet. WHAT A HUGE F
in PROBLEM WE HAVE HERE!

Microsoft, where is the solution?

 

[Amer Mahmud]

I am facing the same issue. I am thinking it might be due to the sheer number of named ranges I use as this workbook has only recently started to face this issue. I had one named range disappear twice, then two distinct ones as well. Very annoying.

 

[WallyWallWhackr]

Do you update your Windows OS and other applications, like Office
regularly
?
Everything I have read about this 'problem' was dated a couple years ago.

Update regularly. I have sheets with well over a hundred, and they are
all there, and when I examine them in the name manager dialog, I can see
the values for each as well. Some are columnar, some are table style, and
most are single cell "ranges". So I use them as variables that reference
the current value in single cells in most instances. I have never seen
my workbooks experience this. I have always kept my system updated
though. Could this be your issue?

I am facing the same issue. I am thinking it might be due to the sheer
number of named ranges I use as this workbook has only recently started
to face this issue. I had one named range disappear twice, then two
distinct ones as well. Very annoying.

Keep your line lengths below 73 characters. It is very annoying.

Uhhh... ^^^ That was a *long* time ago.