I have a problem with .xlsm files that are saved to SharePoint. Sometimes when I open a file up, I get the error "Can't find Project or Library". I can't view the references as I just get error messages in the VBA editor so I don't know what might be unchecked. I have always thought the file was corrupted and would restore an older version but I have a coworker who was able to open the file just fine. The difference is that she has SharePoint files macro-disabled so it opens without the macros being "available". So the file is actually okay. But does anyone have any ideas about how I could fix the missing library? Typically the only references I have checked are:
Visual Basic For Applications
Microsoft Excel 16.0 Object Library
OLE Automation
Microsoft Office 16.0 Object Library
Microsoft Forms 2.0 Object Library
If I try to save the file EXCEL Crashes.
Thoughts?
Visual Basic For Applications
Microsoft Excel 16.0 Object Library
OLE Automation
Microsoft Office 16.0 Object Library
Microsoft Forms 2.0 Object Library
If I try to save the file EXCEL Crashes.
Thoughts?
