Source: I rarely use this approach so was surprised by the greyed out choice. I have a worksheet with a small amount of data, and when i click the pivot table button it automatically creates the pivot table in a new worksheet. Outside of the table, i have various calculations, 12 month trend, 3 month trend, current month compared to trends etc. > i have a spreadsheet of data that i want to use a pivot table with. However, > excel won't let me We could just as easily have created a new data table with all of our data on another worksheet, and changed our pivot table to point at the new data. How do you update pivot tables automatically? What are the best uses of pivot tables? I am running excel 2011 for mac. from i2.wp.com I have a worksheet with a small amount of data, and when i click the pivot table button it automatically creates the pivot table in a new worksheet. What Elements Are In a Strong Spreadsheet? (Contiguous.
Also, i cannot move the pivot table from the new worksheet it is created in, to my existing worksheet.