Application screenupdating not working in excel 2016
However, due to my cross-platform constraint, I could not use her method as presented.Instead of using Active X controls, which are not implemented on the Mac, I used the Form Control Combo Boxes, usable on both platforms.
For each report filter field, the code checks for the Select Multiple Items setting, and changes it on all the pivot tables with the same report filter field.
I am honored that Debra Dalgleish presented my code in her Contextures Blog. Please feel free to contact me with questions or errata.
Return To Top The end of the above project is to take the list of calls and turn them into a mind map.
I hope you had a safe and happy New Year’s Eve celebration, and are off to a good start in 2012. To see the steps for copying the code into your worksheet, and an explanation of how the code works, you can watch this short Excel video tutorial.
Things got a bit rowdy at the Contextures office party, and I found these guys passed out on the floor, the next morning.