Share via

Table name error

Anonymous
2024-11-13T11:53:05+00:00

Hello!!!

I made a table wich i named it "MyTable" and when i insert in another sheet the formula "=MyTable" it gives me an error: "#VALUE!".

Can you help me with this issue?!?!

Thanks!

Microsoft 365 and Office | Excel | Other | 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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-11-14T11:06:00+00:00

    Looks pretty fine, no issues.

    I guess you have Excel 2019 or an earlier version, this versions do not support dynamic arrays, so a simple formula =MyTable returns an error.

    You have enter an array formula in a area that has the same size as the table:

    F1:I15: {=MyTable}

    Any questions?

    Andreas.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-11-14T10:46:25+00:00

    Was this answer helpful?

    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-11-14T08:02:12+00:00

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-11-14T07:20:43+00:00

    How can i share the file with you?!?

    Was this answer helpful?

    0 comments
  5. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-11-13T14:53:59+00:00

    The formula is fine, the issue is something else in your file.

    We need to see your (sample) file.
    Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

    Andreas.

    Was this answer helpful?

    0 comments