Named range creating reference to "MXL2.xlam" in named range

[EricMBA]

I have never had this happen before in all my work with named ranges.

I created some named ranges to reference INDEX() functions that are row specific in a table. For example: "=INDEX(A6Bals,LastRow)". The Named Range works fine until I close and reopen. When I reopen, all of my cells with this function in them show "?NAME" error. When I open the Name Manager and select this Named Range, somehow the Named Range has become "INDEX(A6Bals,MXL2.xlam!LastRow)". Can anyone tell me why this happens and if there is a fix?

Thanks!

 

[EricMBA]

I may have corrected the error. I noticed that some of my named ranges may be similar to (or the same as) some references that may already be stored by Excel. So I changed all of my references to begin with an "r" and all of the numbers to begin with an "i". I saved, closed, and reopened a few times, and the problem did not appear again. If anyone knows either that this was or was not the issue, please let me know.

 

[Fluff]

It looks like Xl thinks you are trying to call a function in the MXL2 add-in