Office Connector Web HelpOnline Help

OCIUpdateLinks Macro

Contents Index


 Excel stores the full path to the add-in file for workbook formulas.  This fact can cause problems when Office Connector Import has been installed to different folders on computers that share a workbook.  Office Connector Import automatically compensates for this scenario when a workbook is opened, but workbook protection can prevent the process from working.  In such cases, you will receive an error message similar to the following:



To handle this special case scenario, the OCIUpdateLinks macro has been provided so you can write VBA code that unprotects the workbook, then calls OCIUpdateLinks (which fixes the path information for the add-in formulas) and then re-protects the workbook.  Please contact support for assistance if you require additional information.


Content updated 5/29/2012

Copyright © 2012 Event 1 Software, Inc.  This documentation may not be copied in full or in part without written permission from Event 1 Software, Inc.