I am just getting started with PowerPivot and reading PowerPivot for Excel 210... by Russo and Ferrari.
I have populated the PowerPivot Window with data exported from three Access tables.
I now want to create a Pivot table from the PivotTable button on the ribbon.
When I do that I get the the message box and I specify I want a new Worksheet.
When I click the OK button, I get the message that states, "Command was canceled please press F1
to get the help topic, "Excel Window: PowerPivot Field List" for more details.
I read the details which does not help.
What is wrong, and how can I get around this problem preventing me from creating a new
worksheet?
I have populated the PowerPivot Window with data exported from three Access tables.
I now want to create a Pivot table from the PivotTable button on the ribbon.
When I do that I get the the message box and I specify I want a new Worksheet.
When I click the OK button, I get the message that states, "Command was canceled please press F1
to get the help topic, "Excel Window: PowerPivot Field List" for more details.
I read the details which does not help.
What is wrong, and how can I get around this problem preventing me from creating a new
worksheet?
