You can do some testing pretty easily.

And to make working with names easier, get 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

WhytheQ wrote:

already got that program thanks Dave.
i'm wondering if named ranges cause a problem when using Break Linke.g

BookA Sheet1 has a formula "=myDate" in a cell which refers to Sheet2
If Sheet1 is then copied over to a new book will Break Link be ok?

J

--

Dave Peterson