There is a pretty simple fix to the following error message
“Object reference not set to an instance of an object”
- Log out of the Add-In
- Close out of all Excel windows entirely. If this error is from the Word add in, instead close all Word documents.
- Restart your computer
- Re-open Excel and Word
- Log in