Old, past its sell by date, workbook that can't be upgraded that I'm trying to nurse across the finish line. Just wondering if there is anything I can do as becoming unworkable. Latest issue is if I try to change the row filter it takes forever to finish calculating. I thought there was some kind of caching going on so these kinds of answers came up quickly. They did do back in the day so I'm wondering if there is some cache somewhere that needs clearing out or anything else that would have turned it to treacle? Adding an existing measure to the same pivot doesn't take too long so seems odd that change the filter/slicer is so bad.
Any suggestions appreciated
Mike
Any suggestions appreciated
Mike