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.
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.
Dreamweaver creates the links to other pages in your site using document-relative paths.Are you familiar with the obstacles and opportunities they are facing?