I tried to set up a connection to the table but all the values came in the pivot table as 1 which is incorrect. Thanks Matt Dont think this is quite what I was after.
I wan't the pivot table to automatically include any data that is added to the table in the main work book.
I have another workbook called Team View which needs to have a pivot table based on the table in the Main Data workbook.
I tried to isert the pivottable and click to the table in the Main Data workbook but instead of referencing the table it only references the cells i select to if data gets added to the main table it won't be included in the pivot table.
The commentator said "the future is looking good, can you imagine a front line of Brooks, Bale and Woodburn"Yes did well MB, he created Waless best 2 chances after he came on despite looking a little nervous at first.Equipped with this tool, man outstrips the efficiency of not only all machines but all other animals as well. Wishing to immerse myself in the culture/language, I turn to S4C. Looks like they see him more as a winger for now, its going to be interesting to see what his best position will be as he developes for both club and country.Left the house in shorts this morning for a spin up the fells on the bike, bit of springtime training for the Enduro in a fortnight.Our owners can comfortably back Wilder in Jan knowing they have a safety net to recoup investment.