PDA

View Full Version : Sleeper: Do Not Update Links - On WB Open



stapuff
05-13-2005, 12:07 PM
Is there a way for the links to other workbooks not be updated on WB open?

Thanks,

Kurt


Using xl2000

Bob Phillips
05-13-2005, 12:37 PM
If you are opening the workbooks from code, you can use


Workbooks.Open FileName:="YourFile.xls", UpdateLinks:=0

stapuff
05-13-2005, 02:15 PM
xld -



Thanks for the response. I figured after doing some research that I couldn't unless through another macro.

Thanks again,

Kurt