Experts,
How are you doing?
I have many reports which I run that have pivot tables to break-down the data into usable pieces of information. The problem is, at any given time, I might have 20-30 pivot tables to update.
Attached Sales Activity Query 02-2008-Printable.xls has a pivot table on Worksheet Sum of Activities. For this example, I have set the second worksheet Sales_Activity_Query with data in rows 1 to 199. In the third worksheet Sales_Activity_Query (2) the data is present in cells 1 to 464.
In the past, if a data was longer or shorter than the last data set used, I would have to right click on the pivot table, select pivot table wizard, back, and then change the last digit in the range to reflect the new ending point. I only want to update the pivot table based on worksheet Sales_Activity_Query, however, I put the other worksheet in, so that we could have data to add or subtract, to illustrate how another data set could either lengthen or shorten the amount of rows in use.
1. Is their a way to say something like fill down or select to end , so that it automatically increases or decreases the range based on the data the is present.
2. After data has been changed (and range recalculated) can the pivot table then update? I had it set to update on open, but that does not help because I have add the data after it is already open
3. Finally, in my pivot table output (worksheet Sum of Activities) I have colored, by hand, the cells to be white then gray, alternating on each line. Can this be done automatically as well, so that I dont have to go in and clear out the lines, and or change colors if the users listed change (which happens almost every month)!
Thank you in advance!
Regards,
Kevin
***edited for content, M_matt***
Start Free Trial
