A formula in this worksheet contains one or more invalid references
Posted on 2009-05-17
I am using excel 2007 and I have several macros, vba code and formulas. I will save my workbook and have no problems. Then when I reopen it, it will give me the error message: "a formula in this worksheet contains one or more invalid references". Then I if I don't change anything and reopen it, half of the time it does not give me this error message. I have tried to identify the issues in the worksheets by doing what other people have said. This includes: hitting F5 and checking the formulas, searching for #REF!, and using vba code to identify the errors. Can anyone tell me how to get rid of this or how to figure out where the error is? Thanks.