Wise people of the forum... I'm stuck...
I have an issue when I run "refresh all" for the pivot tables. Somehow it is trying to get data from a Table3 which doesn't exist. I get the message "we couldn't get the data from "Table3" in the workbook. It then goes on to the next message of "One or more connections didn't refresh operation was cancelled. Would you like to refresh the remaining connection?" I say yes and thing update.
If I update each pivot table separately thing are fine it the refresh all the killing me. The issue is when I use a vba to refresh all pivot tables when a cell changes I get this message. Ugh
I cannot find table 3 as it seems to not exist. How can I correct this situation...
Thanks so much in advance.
KH
I have an issue when I run "refresh all" for the pivot tables. Somehow it is trying to get data from a Table3 which doesn't exist. I get the message "we couldn't get the data from "Table3" in the workbook. It then goes on to the next message of "One or more connections didn't refresh operation was cancelled. Would you like to refresh the remaining connection?" I say yes and thing update.
If I update each pivot table separately thing are fine it the refresh all the killing me. The issue is when I use a vba to refresh all pivot tables when a cell changes I get this message. Ugh
I cannot find table 3 as it seems to not exist. How can I correct this situation...
Thanks so much in advance.
KH