Error message when refreshing a collapsed graph view

Oct 16, 2012 at 1:30 PM


I get an error window  when doing a "refresh graph" (ctrl+R) on a collapsed view of a graph- Excel does not crash.

Graph info:  1335 vertices, 4520 unique edges

NodeXL version



An unexpected problem occurred.  If it occurs again, please copy the details to the clipboard by typing Ctrl-C, then post the details to  Details:  [COMException]: Exception from HRESULT: 0x800AC472   Server stack trace:    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._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, TryGetValueFromCell`1 oTryGetValueFromCell, Dictionary`2& oValueDictionary)    at Smrf.NodeXL.ExcelTemplate.SheetHelper.TryGetAllRowIDs(Dictionary`2& rowIDDictionary)    at Smrf.NodeXL.ExcelTemplate.SheetHelper.SetLocations[TLocationInfo](ICollection`1 locationInfo, Rectangle graphRectangle, String xColumnName, String yColumnName, String lockedColumnName, TryGetRowIDAndLocation`1 tryGetRowIDAndLocation)    at Smrf.NodeXL.ExcelTemplate.Sheet5.SetLocationsOfCollapsedGroups(GraphRectangleEventArgs e)    at Smrf.NodeXL.ExcelTemplate.Sheet5.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)

Oct 17, 2012 at 6:25 PM

Does the problem occur on this workbook every time you try to refresh the graph?  If so, please send me the workbook and tell me the steps I need to follow to get the problem to occur.  (Is it as simple as opening the workbook and clicking Show Graph?)

I'll send you an email address separately.

-- Tony