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 strukturerede referencer 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.

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!