I have a file that is populated, call it dependent, by another file, call it
master, by way of a macro in the master file. The dependent file shows that
it needs to be updated because of links each time it is opened. The macro in
the master file copies and pastes special values into the dependent file. I
have used this method on other projects with no links being formed.

In the dependent file, I have searched for .xls on all tabs to see if I
could find the link, no results. I have shown the formulas on all tabs in
the dependent file, there are none just values. Finally, I went in and broke
the link in the dependent file.

What do I need to change to make the information copy over without the link
being formed?

Thanks

Hi
use the following addin to find these links:
goto: http://oaltd.co.uk/MVP/Default.htm

and search for Findlink.zip
(http://oaltd.co.uk/DLCount/DLCount.a...e=FindLink.zip)

--
Regards
Frank Kabel
Frankfurt, Germany

Dave wrote:
I have a file that is populated, call it dependent, by another file,
call it master, by way of a macro in the master file. The dependent
file shows that it needs to be updated because of links each time it
is opened. The macro in the master file copies and pastes special
values into the dependent file. I have used this method on other
projects with no links being formed.

In the dependent file, I have searched for .xls on all tabs to see if
I could find the link, no results. I have shown the formulas on all
tabs in the dependent file, there are none just values. Finally, I
went in and broke the link in the dependent file.

What do I need to change to make the information copy over without
the link being formed?

Thanks