This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

If you want to link multiple cells from another worksheet, you can use an array function, which lets you link a range of cells using one formula.

For Excel 365, formulas that return a set of values (or an array) are able to spill. Therefore, you can have your formulas spill when using simple calculations, as we did here, and also when using ...

How to use Excel’s find feature to highlight or delete matching values Your email has been sent Excel's Find feature offers more than just finding values if you know the right steps. When ...

Crisis averted–kind of. Permission to copy the entire workbook is another problem. For instance, if you open a protected Excel file in the browser edition, you can see hidden formulas.

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.