Prev: @ symbol in field
Next: Lookups?
From: Ryan on 21 Dec 2009 07:24
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.
From: JLatham on 21 Dec 2009 08:05
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.
From: Ryan on 21 Dec 2009 09:10
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.
 | 
Pages: 1
Prev: @ symbol in field
Next: Lookups?