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.

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.

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.