B
Bill Bedal
Group'
I am using excel 2003 and when I make a new workbook, I typically make a
spreadsheet then copy it, rename it and continue this several times. The
spreadsheet is used to track data from laboratory experiment results. The
problem is that when I copy the sheet I get a warning message that says that
the destination sheet contains the same range name as the original, and asks
me if I want to use the same name or rename it. The problem is that I do not
have any ranges named, and when I look under insert - name - define, There
is a whole list of named ranges referring to a path that does not even exist
on my computer but to a old file created by a colleague about 4 years ago
that no longer exists. I delete all of the named ranges (~ 25) and when I
copy a sheet, they all come back. The workbook is not linked to any other
workbook. If this is not weird enough, the name referred to in the warning
message is not in the many range names that mysteriously appear in the
worksheets. We are networked, but the path that the range names point to is
not shared on my colleague's computer.
I am not the only one that is experiencing this annoying problem, and am
wondering if anyone knows of a solution.
Others that have the same problem are using office 97. My operating
system is XP professional. Please help.
Please respond to this news group.
I am using excel 2003 and when I make a new workbook, I typically make a
spreadsheet then copy it, rename it and continue this several times. The
spreadsheet is used to track data from laboratory experiment results. The
problem is that when I copy the sheet I get a warning message that says that
the destination sheet contains the same range name as the original, and asks
me if I want to use the same name or rename it. The problem is that I do not
have any ranges named, and when I look under insert - name - define, There
is a whole list of named ranges referring to a path that does not even exist
on my computer but to a old file created by a colleague about 4 years ago
that no longer exists. I delete all of the named ranges (~ 25) and when I
copy a sheet, they all come back. The workbook is not linked to any other
workbook. If this is not weird enough, the name referred to in the warning
message is not in the many range names that mysteriously appear in the
worksheets. We are networked, but the path that the range names point to is
not shared on my colleague's computer.
I am not the only one that is experiencing this annoying problem, and am
wondering if anyone knows of a solution.
Others that have the same problem are using office 97. My operating
system is XP professional. Please help.
Please respond to this news group.