A Formula In This Worksheet Contains. Navigate to your Data Tab >> Queries & Connections >> Edit Links and see if any of your links contain errors in them. Most columns have a validation rule that contains a named range that is a structured reference to another Excel table.
It will test a specified cell to see if it contains a formula. You will find an example in this post. In my experience, many Excel users get frustrated and confused when they try to protect the worksheet cells that contain formulas.
Match the error message in your Google Sheet to the sections below, and find out what might be causing your error.
Copy a formula containing a reference When you copy a formula that contains references to other cells, the copy function will change the references. "Oh My God" excel formulas not working in my report.
If that does not work then check the charts on the workbook. Navigate to your Data Tab >> Queries & Connections >> Edit Links and see if any of your links contain errors in them. Search for the square bracket [ in all worksheets of your file.