The key to this is that you would need to create a list of users that either had the option to calculate or not, and take that into account when firing the past routine.Unless critical though, I'm not sure I'd want to go there as it could be dififcult to maintain and could slow down your workbook to a massive degree depending on how big it is.Could a macro be used to update our workbook links automatically on a periodic basis?A: I would not recommend a macro approach to solving this problem.On Time mdte Scheduled Time, "Refresh Data" End Sub Sub Stop Refresh() Application.On Time mdte Scheduled Time, "Refresh Data", , False End Sub If you like these VB formatting tags please consider sponsoring me in support of injured Royal Marines but it is giving me this error Runtime error 1004 Method 'Update Link' of object'_Workbook' failed.
Is it possible to suppress the warning when the link is broken? From the discussion with @Siddharth Rout we see now the cause is different settings for different Excel versions: most likely you use Excel 2010 or later (Siddharth Rout has 2010 as well), while I'm using 2007 and see no warnings at all if links are OK. Open Filename:="C:\Book1with Link To Book2.xlsx" Application. Except a good testing practice and very important solved case (I may face such issues everyday while sending my workbooks to 3rd party, and now I'm prepared), 2 more things learned: Thanks very much to everyone who contributed to the solution, and especially OP who raised the question.Instead, you should enable automatic link updates in Excel 2013 by selecting File, Options, Trust Center, Trust Center Settings, External Content, and under the section labeled Security settings for Workbook Links, select Enable automatic update for all Workbook Links, and then click OK.Because this action grants automatic “write permissions” to all workbooks, Microsoft does not recommend this setting (because this setting is riskier as it removes the security barrier requiring users to manually authorize updates); but if you are confident that all of your workbooks are safe, this setting adjustment may help resolve your link update issues. Carlton Collins ([email protected]) is a technology consultant, CPE instructor, and a Jof A contributing editor.This is generally the area where 3rd party apps install their add-ins (they are written in COM, rather than VBA, and are distributed and installed with the application rather than separately.) I'd be surprised if there wasn't anything there. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site. Here is the code used but i am getting an error .anyone's help on this issue is truly appreciated or any other suggestion to tackle this scenario.