So, you can delete the pivot cache to get the file size of your Excel workbook decreased. To do that, click on a cell in your pivot table and then go to the PivotTable Analyze tab.

You can delete a pivot table in Excel with a few clicks on a Mac or Windows PC. Here are two ways to do it.

When you need to delete records based on a single value in Microsoft Excel, use this Visual Basic procedure. It can make your life a lot easier.

Delete all formatting At times, your colleagues may go overboard with formatting options in Excel. With lots of colors, misalignment, and background shades, your workbook can feel like a total mess.