I am new to PowerPivot. I have PowerPivot to go out and query my SQL Server database and return the correct values. I selected PivotTable and created a pivot table on a new worksheet which is all working correctly.
Each day sales data is updated, so I need to refresh the data that is available to my Pivot Table. I can launch the PowerPivot Window and run the Refresh and my data updates just fine.
But I can't seem to get the connection between this PowerPivot result set and my original Pivot Table. It only is letting me create a new worksheet every time.
I would appreciate any assistance with how to get this working.
Thanks, Cindy
Each day sales data is updated, so I need to refresh the data that is available to my Pivot Table. I can launch the PowerPivot Window and run the Refresh and my data updates just fine.
But I can't seem to get the connection between this PowerPivot result set and my original Pivot Table. It only is letting me create a new worksheet every time.
I would appreciate any assistance with how to get this working.
Thanks, Cindy