Forum Discussion
Advanced Slicer Help Please
I have her a datafile with all the data and figures copied and pasted from a public database to maintain corporate confidentiality. My question is rather straightforward. How can I create a slicer fo...
interesting you seem to be just a little behind since you DO have LET() but don't have LAMBDA(). Go to File, Account, and that is where you can see what build of Excel you have. AND there is a button Update Options and you can try the Update Now option.
- Tried it all it doesn't seem to work. But I love what you accomplished and want to use it........
- a coworker had a similar issue. something was configured such to not do updates.
How about trying it using excel in the browser (OneDrive / Sharepoint)- No avail--online is terrible and riddled with useless (it not for power users nor does it work). If there was only a way to get it to work or if I can change out the formula with something else. I don't know anything but I can follow directions. I now pivot tables and little about power query and that it.