Learn how to use the secret hidden Excel FILES function in your Microsoft spreadsheets to easily retrieve file names and metadata ...

Excel 2013 will attempt to preserve the XLS format when you save the file, but you can choose the XLSX format from the drop-down box next to File Name to save it in XLSX format.

I have a bunch of DVDs, each filled with dozens of files. I want to create a list of the contents of these discs and put it into a spreadsheet. I want to list the file name, type and size. So far ...

The file name or path does not exist The file is being used by another program The workbook you are trying to save has the same name as another Microsoft Excel cannot access the file ...

Microsoft Excel has several features designed to help you recover unsaved versions of files and prevent data loss.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.