Help on excel error message _xlfn.FORMULATEXT

[ultimathor]

I recently installed Excel 2011 on my new iMac so it's the Mac version. When I started using excel I keep getting the following message:

"The name, _xlfn.FORMULATEXT, either conflicts with a valid range reference or is invalid for Excel. The name has been replaced with _1__xlfn.FORMULATEXT.

You may still need to manually update any references tothis name used in VBA code or as text arguments in functions. You must close and reopen the workbook before these changes take effect."

I don't have any such name in the workbook or in the VBA code. I've tried searching for anything like it online but without success.

I hope that someone on this forum can help me understand what is going on.

Thanks .

Thor

 

[Xiq]

Hi Ultimathor,

I found the following post via Google:
http://www.mrexcel.com/forum/excel-questions/602248-odd-message.html

 

[ultimathor]

Hi Xiq,

Thanks a lot. Had never heard of that tool before but it's really cool.

I'm no longer getting the error box but I'm still a bit unsure of why it happened in the first place.

Take care,

Thor