Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 16th 04, 07:51 PM
Dave
 
Posts: n/a
Default File asks to update when no links were created

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

  #2   Report Post  
Old December 16th 04, 08:10 PM
Frank Kabel
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
upgrade to excel 2003 update broken links error tigger Links and Linking in Excel 0 December 1st 04 06:39 PM


All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017