A Formula In This Worksheet Contains One Or More Invalid References

Asked By Roodger Keith 0 points N/A Posted on - 11/26/2020

I am working on formulas with Excel. I am getting the following error when I try to add a new row in my excel – A formula in this worksheet contains one or more invalid references. Please guide me to overcome this error.

• Status: Open
• Question Views: 34
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Hardware
• Question Tags: Windows

Answered By Mark C Costello 0 points N/A #345532

A Formula In This Worksheet Contains One Or More Invalid References

The following steps can help you overcome the error – “A formula in this worksheet contains an invalid reference.

a. Open Excel.
b. Go to the Formulas tab.
c. Click on Error Checking -> Error Checking.
d. Press and hold Alt.
e. Press E and leave it. Do not leave Alt.
f. Press G and leave it. Do not leave Alt.
g. Press S and leave it. Do not leave Alt.
h. This is known as Alt + EGS.

i. Match your settings with the image -> OK.
j. Press CTRL+F.
k. Search for #
l. Open Name Manager.
m. Check for errors in each of the Names.
n. Check all chart series individually if you use charts.

About Mark C Costello

Questions
4

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/26/2020
• Question Category: Hardware