Afternoon everyone,
i made a tool for my office staff to use for everyday purpose, but i am having some issues getting it to be compatible in xls format i created it in xlsx and saved it in xls. Now when some on my staff go to open it it asks to update and after its done i get a # name error and the information is not generated in the cell. can some one look at my sheet and maybe give some insight please.
The IFERROR function doesn't exist in versions of Excel prior to 2007.
You also have a circular reference in D2.
Entia non sunt multiplicanda sine necessitate
The IFERROR() function is not compatible with earlier versions of excel...
you should replace with formula like, in F2
Please Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Ok well i have tried removing that before because i was thinking the same thing, and once i remove it the formula dosent work at all!
Ok thanks NBVC
This part in the D2 formula: MATCH($D$2,PO_ref!$A$1:$E$1,0) there is no names in PO_ref!$A$1:$E$1... do you mean? MATCH($D$1,PO_ref!$A$1:$E$1,0)
So i will be able to create this in xlsx but save it in xls and my employees will be able to view all the information with no code
If you use .xls compatible functions, yes you can create in 2007 and save as 2003 for others to view/use.
Yeah i seen the part in D2 already took care of that. thanks you guys.
BTW what does the ISNA function stand for and do? pretty much the same as IFERROR
ISNA() checks to see if the result of an argument is #N/A error and returns TRUE or FALSE
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks