I am having a problem with a formula/formulas not recognizing a named range in the formula. Specifically, the "refer to" in the named range creates a list of tabs in my workbook. I could give more specifics about that, but I suspect my solution is elsewhere, because my colleague does not have the same problem... when he sends me a file I can see it is working properly, but once I press the "Enable Editing" button the formulas all revert to #NAME? errors. Also, if I create a named range, and use it in a formula it works. But when I save, close, and re-open, the same thing happens... all formula referencing that named range change to #NAME? error. Is there a setting I need to change?
Bookmarks