Share via

Hi I made an excel data table but it does not work. Anyone could understand why?

Anonymous
2024-07-01T06:24:14+00:00

Here the link:

Book1.xlsx

The cell k23, which is linked to the cell f4 of the excel data table (the font is white) and the cell e7 (the central point as an outcome of the excel data table) should be equal but they are not. And also the other values of the excel data table are not correct

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-07-01T09:22:05+00:00

    I assume that you meant I7 instead of E7.

    There are two problems:

    1. You cannot use formulas in the cells immediately above and to the left of the data table. These cells must contain constants. So use copy / paste values to copy the value of B8 to I4 and the value of B10 to F7.
    2. You switched the row input cell and column input cell. Since you cannot edit the TABLE formula, you'll have to clear it, then create it again.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-07-01T09:34:07+00:00

    Thank you Hans for your answer. I pasted the values and it works perfectly.

    Thanks again for your kind support.

    Best regards

    Massinmiliano

    0 comments