Formulas do not reference the cells that you intended to reference after you sort a range in Excel 2013

Symptoms

Assume that a range of cells contain formulas in a Microsoft Excel 2013 worksheet, and the formulas use cross-sheet references that reference cells in the worksheet. After you sort the range, the formulas in the sorted cells do not reference the cells that you intended to reference.

Cause

This issue occurs because cross-sheet references are absolute references instead of relative references. Therefore, when you sort the range, the formulas continue to reference the same cells.

Workaround

To work around this issue, use relative row references and same worksheet references in the formulas. Then, sort the range.
Özellikler

Makale No: 2755143 - Son İnceleme: 6 Kas 2012 - Düzeltme: 1

Microsoft Excel 2013

Geri bildirim