Hi, sometimes when I refresh a pivot table a dialog box pops up and asks 'Do you want to replace the contents of the destination cells..' This is really annoying since I refresh the pivot table within some code in a macro that runs automatically. Therefore when this diolog box comes up and asks...
Hi, whenever i refresh a pivot table, it often asks me 'Do you want to replace the contents of the destination cells..' this is really annoying since this has to happen within some code that runs automatically and when this diolog box comes up asking this question, nothing else can happen until...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.