External excel links not updating

30-Aug-2016 19:27

This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. 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.Note: Instructions for Microsoft Office in “Technology Q&A” refer to the 2013, 2010, and 2007 versions, unless otherwise specified.

This solution works fairly well except that when our employees keep their workbooks open for extended periods of time, they occasionally forget to update their links and end up making decisions based on obsolete data.Microsoft is conducting an online survey to understand your opinion of the Technet Web site.If you choose to participate, the online survey will be presented to you when you leave the Technet Web site. This can be painful when you always want, or don't want, links updated.Could a macro be used to update our workbook links automatically on a periodic basis?

This solution works fairly well except that when our employees keep their workbooks open for extended periods of time, they occasionally forget to update their links and end up making decisions based on obsolete data.Microsoft is conducting an online survey to understand your opinion of the Technet Web site.If you choose to participate, the online survey will be presented to you when you leave the Technet Web site. This can be painful when you always want, or don't want, links updated.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.