Open Microsoft Excel. Go to “ File > Options > Trust Center.” Now, click on the Trust Center Settings button. Select Protected View from the left side. Uncheck all the options on the right ...

Expand your file-protection options via Microsoft Office 2007's Trust Center The most recent version of the popular Office applications centralize security options and add a few new wrinkles.

With that, the cached Excel files are wiped away easy. While you're in the Cache Settings, you can also use the options there to control how long Excel holds onto cached files for.

Press Windows-E to open the File Explorer and search for the deleted worksheet. This option will list Excel, Word and PowerPoint files.

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.