Copying sheet problem

R

Rmagic

Hello

I have a about 20 sheets or more but i adding more but i have a
problem
when i copy them i have a message come up

message:
A formula or sheet you want to move or copy contains
File.dir
file.fullname
file.name
file.sheet.name
name.gg

It ask if i want to use the version if yes the sheet copies fine but
things like the option buttons start to act fun eg only one will select
but the other in the group will not
I have not had this problem in the past with copying sheets (it just
copied)

Help what is all that about

Hope you can help

Thanks
 
D

Dave Peterson

It sounds like that you have a problem with conflicting names.

I'd get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew
Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

Then you'll be able to see what each refers to. And maybe decide what you want
to do next (maybe clean up one of them???)
 
Top