Is there a way for the links to other workbooks not be updated on WB open?
Thanks,
Kurt
Using xl2000
Is there a way for the links to other workbooks not be updated on WB open?
Thanks,
Kurt
Using xl2000
Last edited by stapuff; 05-13-2005 at 12:09 PM. Reason: update information
If you are opening the workbooks from code, you can use
Workbooks.Open FileName:="YourFile.xls", UpdateLinks:=0
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
xld -
Thanks for the response. I figured after doing some research that I couldn't unless through another macro.
Thanks again,
Kurt
Last edited by stapuff; 05-13-2005 at 02:16 PM. Reason: spelling