Clear Automatically Microsoft Teams Cache

Case: You want to delete periodically the cache files of Microsoft Teams to make it lighter. Requisites: Microsoft Teams cache folder path. You can find it by going to your user folder and then go to 'AppData\Roaming\Microsoft\teams\Code Cache'. Steps: Go to 'Task Manager': Right click on 'Task Scheduler' and click on 'Create Task...':   Put a name for the task, set some options and click on 'OK': Under 'Triggers', create or edit a trigger:     Set the frequency for the trigger execution and enable it: Under 'Actions', create or edit an action: Pick 'Start a program' as action, type 'cmd' as program and add as arguments: /c "del /Q /S "C:\Users\<your_username>\AppData\Roaming\Microsoft\teams\Code Cache\*"   Results: The cache files of Microsoft Teams will be clear automatically on the frequency scheduled.  

Showing Pivot Table as Simple Table in Excel

When you are working with pivot tables in Excel you see that they have a grouping scheme where one data of higher hierarchy is shown as a group header instead of being repeated for each row:
 Default pivot table view
However, if you want to see it as a simple table (tabular table with data repetition for each row) you can do it keeping the pivot table properties by clicking on the table to enable the ‘Analyze’ and ‘Design’ tabs in the ribbon:
Activate pivot table options  
Then, go to ‘Design’ tab and under ‘Report Layout’ select ‘Show in Tabular Form’ option: 
Select Show in Tabular Form

After that, your pivot table will be in a classical view (simple, tabular table):

Classic view of pivot table
Now, you will be able to manage this table as a tabular one, for example you can copy it to another sheet if you want to have the information but without grouping.


Popular posts from this blog

Clear Automatically Microsoft Teams Cache

I Need to Send an Automatic Email with Lotus Notes

Turn Horizontal Visio Swimlanes into Vertical Ones