References to tables don't work in earlier versions of Excel

Cause: Some formulas in the workbook contain structured references to tables. This syntax, which refers to tables by name, is not available in earlier versions of Excel and will be converted to cell references. Structured references are generated automatically when the table includes a Total Row. Structured references can also be manually typed in formulas that refer to the table.

Solution:    To ensure compatibility, replace the structured references with cell references.

  1. On the Compatibility Report, in the Results box, click the "Table formulas in this workbook contain references that are not available in earlier versions of Excel" error.

  2. Click Fix. All structured references are changed to cell references.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×