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/comm...el.programming

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." wrote:

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/comm...el.programming

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" wrote:

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." wrote:

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/comm...el.programming

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

"Mike H." wrote:

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" wrote:

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." wrote:

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/comm...el.programming

Mike -

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mike H." wrote in message
...
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" wrote:

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." wrote:

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/comm...el.programming

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.

"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.


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?

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.

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.

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.

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?




"Mike H." wrote:

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/comm...el.programming

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.

On Tuesday, April 29, 2008 8:44 AM Mike wrote:

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/comm...el.programming


On Tuesday, April 29, 2008 9:38 AM Charli wrote:

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." wrote:


On Tuesday, April 29, 2008 9:42 AM Mike wrote:

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" wrote:


On Tuesday, April 29, 2008 10:05 AM Charli wrote:

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

"Mike H." wrote:


On Tuesday, April 29, 2008 11:56 AM Jon Peltier wrote:

Mike -

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mike H." wrote in message
...


On Thursday, September 18, 2008 2:31 PM 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.


On Thursday, October 02, 2008 3:12 PM Steve wrote:

"Bruce Chan" wrote:


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?


On Wednesday, December 10, 2008 1:50 PM Berni 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:


On Friday, March 13, 2009 5:14 PM Chris 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:


On Thursday, April 02, 2009 3:15 PM Mike wrote:

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:


On Friday, April 03, 2009 11:02 AM Chris wrote:

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.

"Mike H." wrote:


On Thursday, January 14, 2010 12:00 PM Trefor wrote:

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?


--
Trefor


"Chrisp" wrote:


On Tuesday, February 16, 2010 10:19 PM invisionz wrote:

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?




"Mike H." wrote:


Submitted via EggHeadCafe
WCF Generic DataContract object Serializer
http://www.eggheadcafe.com/tutorials...erializer.aspx

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?



On Thu, 20 Jan 2011 11:03:55 GMT, Amer Mahmud
wrote:

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.

On Tuesday, April 29, 2008 8:44 AM Mike wrote:

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