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