July 17, 2018
Seems to be a common problem and I also posted here https://www.excelforum.com/exc.....rnces.html with zero luck.
“Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.”
I have gone through the various solutions found with google but can't find any issue or way to fix. It only occurs when I add a new line to CompLog table, there's a couple of dependent dropdowns but nothing major.
The File is hosted on a Win2008 server with excel 2013, I can open on desktop with 365 fine but when I move it to the server I get the above message when adding a new line
I also just converted an existing set of data on a worksheet to a table, the only change I have made, and that gives the same error when adding a new line to the data. In this file the only thing in Name Manager is the table, no links or connections, one of the columns in the table has hyperlinks to pdfs but even deleting them doesnt change it.
February 13, 2021