Reply to thread

Message: [QUOTE="Jesper Audi, post: 3280811"] Sorry when I said external, I simply meant in another workbook on my files. I did go to contextures and found and downloaded the add-in but as you say this is more for external data connections. I wish I could do a macro to help, but I have about 10 sheets in each workbook and several pivot table on different sheets which are in different positions. What I really want is somewhere where the pivot table ranges are defined. If in this case there was only one pivot table range then I should only have to change the range once. I think I shall just have to cut and paste the range into each of the pivot table's source data. Thanks for your help anyway Jesper Audi [/QUOTE]