| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 to 2003 functionality
I have excel 2007 and transferred a file to a user that only has 2003. When
trying save this in the 2003 format the compatibity checker gives me 42 formulas that have significant loss of functionality. All of the formulas have the IFERROR function in them. Is there a fix for this problem? It casuse all 42 of thes formulas to put the #name error in the field. One of the formulas looks like this. Did the IFERROR function even exist in 2003 version? =IFERROR(HLOOKUP(F7,$D$36:$N$40,5,FALSE),"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Drop-Down Functionality in 2007? | Excel Worksheet Functions | |||
| Protecting sheet but keeping list functionality in 2003 | Excel Worksheet Functions | |||
| Transition Link functionality from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
| Problem with Excel 2003 restricting functionality | Excel Discussion (Misc queries) | |||
| Excel 2003 Viewer: No more "Browse in same window" IE functionality? | Excel Discussion (Misc queries) | |||
Threaded Mode
