Hi there,
I'm new to this forum as i can't seem to find related issued to the problem I am having which is causing me a headache!
In summary I have an excel workbook with one data source which I often have to update or add in new rows or remove rows, I then have a number of sheets in the workbook which contain pivot tables and charts, when I hit refresh the pivot is not pulling through any new data so to force it through I've had to change the data source and add in blank rows in the range to which the pivot then updates.
I've also gone down the root of a table name and dynamic named range etc and nothing seems to work which is frustrating as I use the file daily and it's becoming quite manual which defeats the object.
Help required from you excel experts please
Thanks
Emma
Bookmarks