I emailed this perfectly working spreadsheet to another computer and now I'm getting a #NAME? error. What the heck is going on.
I emailed this perfectly working spreadsheet to another computer and now I'm getting a #NAME? error. What the heck is going on.
Last edited by AnnaV; 01-12-2009 at 09:42 PM.
It's an issue with IFERROR.
The file opens properly for me, after giving me a warning about IFERROR being different from previous versions of excel to this one. Once I click OK on the warning that pops up, it fixes the #NAME errors that are initially on the screen.
You may have different versions of excel from one computer to the other?
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
They are different versions, but I put
in the VB editor so it shouldn't make a difference, should it?Please Login or Register to view this content.
Last edited by AnnaV; 01-13-2009 at 06:15 PM.
Anna, please edit your post to add code tags.
Entia non sunt multiplicanda sine necessitate
Anna, you have to enable macros in order to avoid the #NAME error. Close the file, set macro security to Medium (Tools > Macro > Security), reopen the file, and enable macros when prompted.
MK, when you open the file in Excel 2007, it's advising that you have a name conflict with an existing 2007 function.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks