A
Adam White
Hi, hope someone can shed some light on this one because I am an Excel novice.
A user has two copies of a workbook, xls1 and xls2. They were originally the
same (exact replicas) but have become different over time. When she copies a
named range from xls1 and inserts it into xls2, it creates a named range in
xls2 which "refers to" a range of cells in xls1, with the wrong file path to
boot.
I have not been able to replicate this phenomenon in my testing with a basic
workbook but I have seen her do it. Any ideas why this is happening and how
to prevent it? We want the inserted range to refer to cells in the current
workbook, not the one it was copied from.
Thanks
- Adam
A user has two copies of a workbook, xls1 and xls2. They were originally the
same (exact replicas) but have become different over time. When she copies a
named range from xls1 and inserts it into xls2, it creates a named range in
xls2 which "refers to" a range of cells in xls1, with the wrong file path to
boot.
I have not been able to replicate this phenomenon in my testing with a basic
workbook but I have seen her do it. Any ideas why this is happening and how
to prevent it? We want the inserted range to refer to cells in the current
workbook, not the one it was copied from.
Thanks
- Adam