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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.