| 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.
|