Cannot open PivotTable source after VSTO deployment

[Fan Yang]

I deployed xlsm project to a web server. While user runs macro in it to
refresh pivottable, he got error "Cannot open PivotTable source file
'/path/to/repository/[Copy of theworkbook.xls]SheetName'". How to fix this?

 

[Fan Yang]

Refresh pivotTable with code
(http://mokosh.co.uk/post/2009/11/05/vsto-excel-pivot-tables-and-phantom-data/), got similar exception as follows:

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type)
at Microsoft.Office.Interop.Excel.PivotTable.RefreshTable()
at MyWorkbook.Sheet21.btnRefresh_Click(Object sender, EventArgs e)