I have two worksheets in a workbook that generate pivot tables. I have found
that if I run the macro associated with one of them, and then run the macro
for the other, the second one loses data. I think that the problem may be
from the Advanced Filters that I use in both of these macros. They use
different filters, and are thus using separate procedures. However, much of
the rest of the code is the same for each macro, with just an if statement in
there to determine some small differences, so in those cases they use the
same procedures. I do not know why I am losing data here. If I just run the
second macro, then it does not lose any data.