Product:
Cognos BI 10.1.1
Windows 2008 R2

Symptom:
Error message when you import a report into Microsoft Excel.

Problem:
M:OperationFailed :PRS-REQ-0760 The operation “/” “” “xts.run is invalid

Solution:
Ensure that allowPathInfo=”true” as set in the IIS web.config file for cognos.cgi or cognosisapi.dll in you \cgi-bin\ folder on the Cognos BI gateway server.

The allowPathInfo=”true” parameter will allow the IBM Cognos for Microsoft Office to work.

Note:
If you get the error COC-ERR-2005 then you have missed the ” ” around true in allowPathInfo=”true”.