| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 Excel file formats
I have a sheet with a user defined function that will run fine in 2003
however when it is opened in 2007 the function only returns a "#NAME?" error. Is this a file format issue or something else? Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2007 Excel file formats
It sounds like the code with the user defined function is not active or
perhaps not even present when opened in 2007. You may need to save the file in 2007 .xlsm format and even after that you may have to copy the code from the 2003 file and add it to the 2007 file. "Ryan" wrote: I have a sheet with a user defined function that will run fine in 2003 however when it is opened in 2007 the function only returns a "#NAME?" error. Is this a file format issue or something else? Any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2007 Excel file formats
Can this be done while keeping the sheet compadible with 2003? It is my
understnading that .xlsm are 2007 documents. "JLatham" wrote: It sounds like the code with the user defined function is not active or perhaps not even present when opened in 2007. You may need to save the file in 2007 .xlsm format and even after that you may have to copy the code from the 2003 file and add it to the 2007 file. "Ryan" wrote: I have a sheet with a user defined function that will run fine in 2003 however when it is opened in 2007 the function only returns a "#NAME?" error. Is this a file format issue or something else? Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting excel 2003 to 2007 file formats | Excel Discussion (Misc queries) | |||
| XL 2007 lose formats when opening file exported from Oracle Discov | Excel Discussion (Misc queries) | |||
| COMPATIBILITY PACK FOR 2007 FILE FORMATS | Excel Discussion (Misc queries) | |||
| No ActiveX controls when reading 2007 file formats into Excel 2003 | Excel Discussion (Misc queries) | |||
| With the new file formats in Excel 2007 what are the worksheet dim | Excel Discussion (Misc queries) | |||
Linear Mode
