Cannot open PivotTable source after VSTO deployment

F

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?
 
F

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top