OMSfields in Spreadsheet Precedents keep getting re-written and you may see this screen:-
Cause:
If Microsoft Office 2016 has been deployed via the Click to Run method then the MatterSphere Excel add-in omsfw.xla copies to the following location:
C:\Program Files(x86)\Microsoft Office\Root\Office16\XLstart
When the add-in enters this location, the Field Codes will not merge correctly.
The default location where it already exists is:
C:\Program Files(x86)\Fwbs\Oms Matter Centre
Solution:
1. Close down all instances of Microsoft Office.
2. In Windows Explorer navigate to C:\Program Files(x86)\Microsoft Office\Root\Office 16\XLstart
3. Delete omsfw.xla
4. Open the Registry and navigate to HKEY_LOCAL_MACHINE\Software\wow6432Node\Microsoft\Office\16.0\InstallRoot
5. Remove the value in the Path key so it’s blank.
6. Load Microsoft Excel.
7. Click on File > Options > Add-ins > Click Go for Excel Add-ins
8. Remove Omsfw (untick).
9. Click Browse and navigate to C:\Program Files(x86)\Fwbs\Oms Matter Centre
10. Select omsfw.xla.
11. Click OK on the Add-ins dialog box.