Great video Chester - thanks so much. Was able to build my button by the 5min mark :)
@ginobilodeau2496
4 жыл бұрын
Thank you, this is by far the most concise and functional video I found on the subject. Great Work!
@AkaExcel
5 жыл бұрын
Chester Tugwell, thank you for your useful #Excel video!
@jeanpierre4370
4 жыл бұрын
Is there a way to add a Time & Date after it refreshes?
@juanpaolo21yt
2 жыл бұрын
u helped me again. thanks alot.
@Lay-z-Panda
2 жыл бұрын
I have a form that needs to be refreshed every a entry is submitted how could I donit
@AkaExcel
5 жыл бұрын
I wish i know, how to autorefresh pivot table every "n" seconds... Have you experienced such issue?
@shantanuwattamwar3920
5 жыл бұрын
Hi .. is there way to know if refresh has been successful or failure.
@armanmontero7867
3 жыл бұрын
Hi, just wanted to ask if how will I use the refresh all PT without the code interfering with the format of the other cells?
@mohammadaijaz4901
3 жыл бұрын
Thanks a lot of million Sir
@BagihBagih
4 жыл бұрын
Tank you
@MarekKoppel
3 жыл бұрын
Thank You!
@ibadkhan481
3 жыл бұрын
It’s not working my source data is not in a table format
@paraskatoch271
4 жыл бұрын
Hello, Thank you for the video. I have a question here, I am trying to refresh pivot charts in the protected sheet having slicer. The problem is in the code. I ran the code, the charts gets refreshed and then the sheets gets protected again. However, the problem with my code is that my slicer stopped working. Can you help me with a code that my query still run, sheet remains protected and i can move my slicer. The only failure i am facing is not getting my slicer functional after the command. M not a VBA expert but this is the code i used - Sub RefreshAllPivotTables() ActiveSheet.Unprotect Password:=“Password” ThisWorkbook.RefreshAll ActiveSheet.Protect Password:=“Password” End Sub How can i click the check box in the option below the protect sheet using VBA. Looking for answers. Thanks in advance
@ChesterTugwell
4 жыл бұрын
Yes, I have come across this problem. Please see www.mrexcel.com/board/threads/protecting-worksheet-but-maintaining-slicer-functionality-and-usability.663169/
@SolomonKinyanjui_sk
4 жыл бұрын
Good work. How can i show PivotTables in Project explorer?
Пікірлер: 16