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.

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

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.