Last seen: Apr 22, 2025
This made for interesting reading; thank you for the link. Not much conditional formatting going on in my workbook, but I finally decided to go a d...
Yes, unfortunately the file must reside on the network. Recently we moved to Virtual Desktop and nobody in the office has a real C: drive as far as I ...
Hi Mynda, It doesn't look like I can get Power Pivot available to everybody in my office, so I don't think I can go this route. I'll have to pla...
Many thanks, Derek. I did as instructed by you and now the wait time went down to about 8-10 seconds on average. Not ideal, but my end users may ha...
Derek, Much better. The wait time went down to about 15-20 seconds. Does it matter exactly where the "Application.Calculation" lines go? Should ...
I adapted the macro from the first link posted by Derek and it works, just extremely slowly and freezes up the workbook. It synchronizes all the slice...
Hi Mynda, I was looking at the dynamic named ranges and combo boxes, but my file doesn't contain the raw data, it's just linked to it through Power...
Thank you, Derek. I was hoping it would be easier and simpler. I started reading the first article and my head is spinning. I'll have to try and pl...
Hi Mynda, Thank you so much for your help. You are right, Premium values are not always unique in my real data. I ended up doing a combinatio...
Angela, I do not have a solution for you, but this has been happening frequently to me too. Microsoft told me that switching to 64-bit version of E...
I was getting an error when I used =Text.PadStart(,4,0). First it was "We cannot convert the value 825 to type Text." so I changed my Code data typ...