Link to Excel file breaks VBA references

We have a SharePoint site that serves as an index into a set of Excel spreadsheets on a file server.  Recently, when the spreadsheet link is selected, it opens Excel, opens the spreadsheet, but Excel's VBA cannot seem to find referenced libraries.  For example, in the Workbook_Open routine there is a Date function that fails.

The symptoms seem to be based on the computer that is being used, not a user account.  Also, when I open the file directly from Excel or the file server, it works just fine.

We are using SharePoint 2010, Excel 2013.  The problem seems to have started after the February 2015 patching cycle.  I've poked around in the SharePoint server event files, but cannot find anything related there.


I've seen this happen before, when libraries are missing, but in this case the libraries still exist, the References dialog does not preface any of them with "MISSING".
  • Edited by ArtWalls 7 hours 35 minutes ago
March 20th, 2015 7:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics