Random NAME error only while running macro

Question

I have a worksheet with a named range formula that relates to another workbook. However, this other workbook utilizes the same named range on several sheets. One of the formulas is this one.

='C:\Account\Onshore'!Account_Balance_USD/'C:\Account\Combined'!Account_Balance_USD

I'll get a% from this formula when I open the workbook. But occasionally, when a macro is executing, the cell changes to #NAME, and I have to press debug, navigate to this cell, and press enter to get the percentage back. I'm curious why it acts in that way.

Answer 1

For those who are wondering what happened to this post, as Toddleson mentioned, I had a named range that was being used, but it was actually tied to another workbook that was typically open but occasionally closed, which caused the "#NAME" to be triggered. Since this workbook ALSO had the same named range for itself, it was wrongly linked. I fixed it by removing the named range that was connected to the other workbook.