We have a word doc with a macro that resides on a shared drive. An application will copy the docm to the users workstation temp directory, open the doc and invoke the macro. This has been working for the past 5 years no problem. Recently some of the user workstations have been updated with an Office update. Now when the macro is invoked it will fail with a "Compile error: Can't find project or library" on the TRIM function. When I open the macro and review the checked references I see:

MISSING: Normal
Normal

So a 'new' normal reference was added and the old one is flagged as missing. If I then uncheck the MISSING: Normal and save the doc and re-open it the macro works.

I have many many docs that will need to be 'fixed' - wondering if anyone has any insite as to what is going on.