Last post Mar 20, 2007 10:31 AM by Bkmzzz
Feb 05, 2007 05:27 PM|contec|LINK
I'm trying to manipulate an Excel worksheet using the Microsoft.Office.Core library. I have the excel addin for analysis services installed, and from my reading of the documentation, it appears as though ExcelWorkbook.RefreshAll should refresh the data.
However, it doesn't seem to do anything.
Is there any way to refresh the external data via the API?
Feb 08, 2007 01:22 PM|contec|LINK
Mar 20, 2007 10:31 AM|Bkmzzz|LINK
Hi! For me Application.CalculateFull works fine