I'm working on a project where the customer wants to publish files from one SharePoint site to another. No prob so far. The challenge is in the fact that this customer is mostly working with Excel files that he wants to publish using Excel services. No prob, except for workbooks that have linked files, they wont publish through Exel services. But I found something to this.

I've created a SharePoint solution that adds a context menu-item "Publish File", where the code checks if it deals with an xlsx, xlsm, ... file or something else. If it is an xlsx file, the code uses the "breaklink" method in order to break all links with other workbooks and just keep the values, works perfect!. Functions like these I found in the "Microsoft.Office.Interop.Excel.dll". I have no problem deploying the SharePoint solution in my development environment, but from the moment I want to deploy to the production server, it has problems with the reference to that interop dll.

Where do I put that interop dll best? I did have to install Excel on the production server....