[COMException]: PivotFields method of PivotTable class failed

[amy]

Details:

[COMException]: PivotFields method of PivotTable class failed

at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)

at Microsoft.Office.Interop.Excel.PivotTable.PivotFields(Object Index)

at Smrf.NodeXL.ExcelTemplate.TimeSeriesCalculator2.CreatePivotTableAndChart(Worksheet dataWorksheet)

at Smrf.NodeXL.ExcelTemplate.TimeSeriesCalculator2.TryCalculateGraphMetrics(GraphMetricUserSettings graphMetricUserSettings)

at Smrf.NodeXL.ExcelTemplate.TaskAutomator.TryCalculateGraphMetrics(Workbook oWorkbook)

at Smrf.NodeXL.ExcelTemplate.TaskAutomator.AutomateOneWorkbook(ThisWorkbook thisWorkbook, NodeXLControl nodeXLControl, AutomationTasks tasksToRun, String folderToSaveWorkbookTo)

at Smrf.NodeXL.ExcelTemplate.TaskPane.AutomateThisWorkbook()

at Smrf.NodeXL.ExcelTemplate.TaskPane.CommandDispatcher_CommandSent(Object sender, RunCommandEventArgs e)

at Smrf.NodeXL.ExcelTemplate.RunCommandEventHandler.Invoke(Object sender, RunCommandEventArgs e)

at Smrf.NodeXL.ExcelTemplate.CommandDispatcher.SendCommand(Object sender, RunCommandEventArgs runCommandEventArgs)

at Smrf.NodeXL.ExcelTemplate.CommandDispatcher.SendNoParamCommand(Object sender, NoParamCommand noParamCommand)

at Smrf.NodeXL.ExcelTemplate.ThisWorkbook.AutomateThisWorkbook()

at Smrf.NodeXL.ExcelTemplate.ThisWorkbook.AutomateTasksAfterImport()
—————————
OK
—————————

[Harald Meier]

This feature is invoked during the creation of the Time Series analysis spreadsheet. Pivot Tables appeared in Office 2010 and later.

If you are using Office 2007 you can turn this off in NodeXL> Graph> Automate> Time Series (uncheck).

Also please check if your settings are correct under NodeXL> Analysis> Graph Metrics> Time Series.

If you cannot solve the problem, feel free to request Tech Support on this page.

[Author]

Posts