Error message while refreshing graph: [COMException]: Exception from HRESULT: 0x800AC472

Aug 8, 2014 at 6:32 PM
Details:



[COMException]: Exception from HRESULT: 0x800AC472



at Microsoft.Office.Interop.Excel._Application.Intersect(Range Arg1, Range Arg2, Object Arg3, Object Arg4, Object Arg5, Object Arg6, Object Arg7, Object Arg8, Object Arg9, Object Arg10, Object Arg11, Object Arg12, Object Arg13, Object Arg14, Object Arg15, Object Arg16, Object Arg17, Object Arg18, Object Arg19, Object Arg20, Object Arg21, Object Arg22, Object Arg23, Object Arg24, Object Arg25, Object Arg26, Object Arg27, Object Arg28, Object Arg29, Object Arg30)

at Smrf.AppLib.ExcelUtil.TryIntersectRanges(Range range1, Range range2, Range& intersection)

at Smrf.AppLib.ExcelTableUtil.TryGetTableColumnData(ListColumn column, Range& tableColumnData)

at Smrf.AppLib.ExcelTableUtil.TryGetTableColumnData(ListObject table, String columnName, Range& tableColumnData)

at Smrf.AppLib.ExcelTableUtil.TryGetTableColumnDataAndValues(ListObject table, String columnName, Range& tableColumnData, Object[,]& tableColumnDataValues)

at Smrf.NodeXL.ExcelTemplate.SheetHelper.TryGetValuesInAllRows[TValue](String sColumnName, TryGetValueFromCell1 oTryGetValueFromCell, Dictionary2& oValueDictionary)

at Smrf.NodeXL.ExcelTemplate.SheetHelper.TryGetAllRowIDs(Dictionary2& rowIDDictionary)

at Smrf.NodeXL.ExcelTemplate.SheetHelper.SetLocations[TLocationInfo](ICollection
1 locationInfo, Rectangle graphRectangle, String xColumnName, String yColumnName, String lockedColumnName, TryGetRowIDAndLocation1 tryGetRowIDAndLocation)

at Smrf.NodeXL.ExcelTemplate.Sheet2.ThisWorkbook_GraphLaidOut(Object sender, GraphLaidOutEventArgs e)

at System.EventHandler
1.Invoke(Object sender, TEventArgs e)

at Smrf.AppLib.EventUtil.FireEvent[TEventArgs](Object sender, TEventArgs e, EventHandler`1 eventHandler)

at Smrf.NodeXL.ExcelTemplate.ThisWorkbook.ForwardEvent[TEventArgs](TEventArgs e, EventHandler`1 oEventHandler)

OK