Compatible with OLAP connections ?

Aug 14, 2013 at 10:43 AM
Does ExcelRefresher support workbooks with OLAP connections ?
Jul 16, 2014 at 11:25 AM
Edited Jul 16, 2014 at 11:25 AM
When I try to refresh a workbook with OLAP connection, I get the error message below. OLAP connection is also an OLEDB connection which is supported according to the project description, no?? It works for OLEDB SQL connection though.

Refreshing C:\Users\roshen\Downloads\Refresh\MACE.xlsx
Error: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALI
Error: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALI

Unhandled Exception: System.ArgumentException: The parameter is incorrect. (Exce
ption from HRESULT: 0x80070057 (E_INVALIDARG))
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFla
gs flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.OLEDBConnection.get_BackgroundQuery()
at ExcelRefresh.Excel.ExcelUtilities.RefreshAll(Workbook workbook)
at ExcelRefresh.Excel.ExcelUtilities.<>c__DisplayClass4.<RefreshWorkbook>b__3
(Workbook book)
at ExcelRefresh.Com.ComHelpers.<>c__DisplayClassa.<UsingWorkbook>b__8(Workboo
k workBook)
at ExcelRefresh.Com.ComHelpers.UsingCOM[T](T reference, Action1 doThis, Acti
1 thenFinally)
at ExcelRefresh.Com.ComHelpers.<>c__DisplayClassa.<UsingWorkbook>b__7(Applica
tion excelApp)
at ExcelRefresh.Com.ComHelpers.<>c__DisplayClass4.<UsingExcel>b__2(Applicatio
n app, Process process)
at ExcelRefresh.Com.ComHelpers.UsingAutomationApp[T](T app, Func2 fnGethWnd,
2 doThis)
at ExcelRefresh.Com.ComHelpers.UsingExcel(Action`1 doThis)
at ExcelRefresh.Excel.ExcelUtilities.RefreshWorkbook(String sourcePath, Strin
g saveToPath, String backupPath)
at RefreshExcel.Program.Main(String[] args)
Feb 25, 2015 at 1:26 PM

I have the same issue with the refresh utility.

Have you been able to solve this?