Unknown name. (Exception from HRESULT: 0x80020006 (DISP_E_UNKNOWNNAME))

Apr 16, 2015 at 5:17 PM
Hello,

I'm trying to run a simple test with powerpivot for excel 2010 and receiving the following exception.

I'm running windows 7 pro 64bit, with excel 2010 32bit, with Microsoft SQL Server 2012 version of PowerPivot.

My content setting for the file are as follows "Always;ArchiveSubFolder;MaximumPriority"

I have the following errors in the event viewer:

ExcelRefresher:

Error C:\ExcelRefresh\ContosoV2\New Microsoft Excel Worksheet.xlsx : Unknown name. (Exception from HRESULT: 0x80020006 (DISP_E_UNKNOWNNAME))

Application Error:
Faulting application name: EXCEL.EXE, version: 14.0.7140.5000, time stamp: 0x5462a671
Faulting module name: EXCEL.EXE, version: 14.0.7140.5000, time stamp: 0x5462a671
Exception code: 0xc0000005
Fault offset: 0x00209678
Faulting process id: 0x2b98
Faulting application start time: 0x01d077e93f62872d
Faulting application path: C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
Faulting module path: C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
Report Id: 803cc6e0-e3dc-11e4-b169-b8763fa816bc

Any suggestions?

Thanks,
John
Apr 26, 2016 at 12:32 PM
You're probably using it with Excel2010 - check older solution - "Excel refresher", not the "Excel refresher 2013".