Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #8874
    amy
    Participant

    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
    —————————

    #8974
    Harald Meier
    Keymaster

    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.

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.