Mark, I wish I knew this tip years ago! Such an easy fix but so well hidden. Thanks for posting
@ExcelOffTheGrid
2 жыл бұрын
Thanks. It is a frustrating little problem. I find it odd that the default is not already set to none. Who wants things listed that aren’t there???!!??
@ekkiwurm7874
2 жыл бұрын
Thank you very much for sharing this video. You explained it so well. In the past I used a macro to clear old items but the way you showed it is much easier and works in workbooks that are not xlsm. Thank you!
@ExcelOffTheGrid
2 жыл бұрын
Thanks Ekki, I'm gald it was helpful.
@mostafael-assy8100
2 жыл бұрын
You have me a solution to one of the most annoying problems in excel that I never knew the solution for. Thank you
@jcarlosquebrado6716
11 ай бұрын
Excellent Tip! I've been struggling with this for a while. I have tools that I built that help me analyse massive amounts of data, but are meant to analyse only that data. I don't need it to cache anything. This will tip will greatly help me, I'm updating my tools right now. Thank you so much.
@wayneedmondson1065
2 жыл бұрын
Hi Mark. Awesome start to 2022! Thanks for sharing these multiple ways to change this setting. Was maddening before I learned how to modify it. Thanks for the tips! Thumbs up!!
@ExcelOffTheGrid
2 жыл бұрын
Thank you Wayne. I really appreciate the support and encouragement you provide (not just to me but to lots of Excel creators on KZitem 😀).
@wayneedmondson1065
2 жыл бұрын
@@ExcelOffTheGrid Glad to support! I learn something new from you every time. Very much appreciate all your efforts :)) Thumbs up!!
@AnushaUppuluri
Жыл бұрын
Thank you so much for this video. Helped save me tons of hours!
@ExcelOffTheGrid
Жыл бұрын
Glad it helped!
@amitgoyallaughterchallenge
Жыл бұрын
Thanks for this video
@ExcelOffTheGrid
Жыл бұрын
You're welcome.
@KS-jy2bs
Жыл бұрын
Very helpful! Thank you :)
@amitgoyallaughterchallenge
Жыл бұрын
My Problem is resolved. thanks for this video
@ExcelOffTheGrid
Жыл бұрын
Great stuff 😁
@jakobhorvath940
Жыл бұрын
Can you change pivot cache settings on Excel for Web?
@ExcelOffTheGrid
Жыл бұрын
Not sure. I’ve never tried. I wouldn’t be surprised if not.
Пікірлер: 21