Share via

Excel formula not working

Anonymous
2024-01-29T03:47:21+00:00

A worksheet in an Excel file will not permit formula to work in a cell. When I use a simple "=A2" cell it results in a =[@Vendor] which is the title of that column. Other worksheets in the file do not have this problem.

HELP!!!

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-01-29T04:33:57+00:00

    Hi JohnnyHale,

    Thank you for reaching out. My name is Leo, a user just like you. I'd be happy to help you with your concern.

    May I know which Microsoft Office version you are currently using? Do you also use any add-ins? It seems that Excel is interpreting the title as a formula. Kindly try adding the formula again, and this time, type it in the formula bar instead of the cell itself. If the issue still persists, turn off automatic formula correction for this specific worksheet. To do this, go to File > Options > Proofing > AutoCorrect Options > Autoformat as you type. Uncheck the box for "Fill formulas in tables." Then check if it resolves the issue. If the issue still persists, please let us know so that we can help you further. We, the community users, are always here to help. Thank you!

    Your understanding and patience will be highly appreciated. I hope I provided a helpful information regarding your concern! Let me know if you have any further questions. Be safe always!

    Best Regards,

    Leo

    Was this answer helpful?

    0 comments