Add-in functions not available

Any help with this would be greatly appreciated.

I am running Excel 2003 on a normal laptop as part of Office Professional,
on Windows XP Professional.

I recently installed (successfully it seemed) an Excel add-in:

"Microsoft Excel Add-in for SQL Server Analysis Services" which is freely
available from the Microsoft web site.

When I try to use its functions, e.g. CUBECELLMEMBER(...), the error "#NAME"
is returned, indicating that Excel cannot see the functions. The add-in has
installed its menus and in all other respects appear to function correctly.

I am also running the Office 2007 Beta 2 which, oddly, has no problem
recognising the functions of the add-in.

I assumed this was some kind of security issue - but what?

I seem to have everything set up correctly in Macro Security. "Trust All
Installed Addins and Tempaltes" is enabled, Macro Security level is "Medium".
Could it be something to do with .NET Framework security? Is the add-in a
VSTO solution? I don't think so because the accompanying help file makes no
such reference.

Thanks for any assistance!

Regards,

Ian Digby

--
Work performed in the spirit of service is worship...Baha''''i Writings

Did you actually check it in the ToolsAddins dialog?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ian Digby" wrote in message
...
Any help with this would be greatly appreciated.

I am running Excel 2003 on a normal laptop as part of Office Professional,
on Windows XP Professional.

I recently installed (successfully it seemed) an Excel add-in:

"Microsoft Excel Add-in for SQL Server Analysis Services" which is freely
available from the Microsoft web site.

When I try to use its functions, e.g. CUBECELLMEMBER(...), the error
"#NAME"
is returned, indicating that Excel cannot see the functions. The add-in
has
installed its menus and in all other respects appear to function
correctly.

I am also running the Office 2007 Beta 2 which, oddly, has no problem
recognising the functions of the add-in.

I assumed this was some kind of security issue - but what?

I seem to have everything set up correctly in Macro Security. "Trust All
Installed Addins and Tempaltes" is enabled, Macro Security level is
"Medium".
Could it be something to do with .NET Framework security? Is the add-in a
VSTO solution? I don't think so because the accompanying help file makes
no
such reference.

Thanks for any assistance!

Regards,

Ian Digby

--
Work performed in the spirit of service is worship...Baha''''i Writings

Bob,

Thanks for this, but there is no entry in the Addins dialog to check. The
add-in has installed a menu and all the options function correctly - except
the worksheet functions are not recognised!

Regards

Ian
--
Work performed in the spirit of service is worship...Baha''i Writings


"Bob Phillips" wrote:

Did you actually check it in the ToolsAddins dialog?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ian Digby" wrote in message
...
Any help with this would be greatly appreciated.

I am running Excel 2003 on a normal laptop as part of Office Professional,
on Windows XP Professional.

I recently installed (successfully it seemed) an Excel add-in:

"Microsoft Excel Add-in for SQL Server Analysis Services" which is freely
available from the Microsoft web site.

When I try to use its functions, e.g. CUBECELLMEMBER(...), the error
"#NAME"
is returned, indicating that Excel cannot see the functions. The add-in
has
installed its menus and in all other respects appear to function
correctly.

I am also running the Office 2007 Beta 2 which, oddly, has no problem
recognising the functions of the add-in.

I assumed this was some kind of security issue - but what?

I seem to have everything set up correctly in Macro Security. "Trust All
Installed Addins and Tempaltes" is enabled, Macro Security level is
"Medium".
Could it be something to do with .NET Framework security? Is the add-in a
VSTO solution? I don't think so because the accompanying help file makes
no
such reference.

Thanks for any assistance!

Regards,

Ian Digby

--
Work performed in the spirit of service is worship...Baha''''i Writings

In the VBIDE, set a reference to the file, and see if you can call the
function directly from VBA.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ian Digby" wrote in message
...
Bob,

Thanks for this, but there is no entry in the Addins dialog to check. The
add-in has installed a menu and all the options function correctly -
except
the worksheet functions are not recognised!

Regards

Ian
--
Work performed in the spirit of service is worship...Baha''i Writings


"Bob Phillips" wrote:

Did you actually check it in the ToolsAddins dialog?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ian Digby" wrote in message
...
Any help with this would be greatly appreciated.

I am running Excel 2003 on a normal laptop as part of Office
Professional,
on Windows XP Professional.

I recently installed (successfully it seemed) an Excel add-in:

"Microsoft Excel Add-in for SQL Server Analysis Services" which is
freely
available from the Microsoft web site.

When I try to use its functions, e.g. CUBECELLMEMBER(...), the error
"#NAME"
is returned, indicating that Excel cannot see the functions. The
add-in
has
installed its menus and in all other respects appear to function
correctly.

I am also running the Office 2007 Beta 2 which, oddly, has no problem
recognising the functions of the add-in.

I assumed this was some kind of security issue - but what?

I seem to have everything set up correctly in Macro Security. "Trust
All
Installed Addins and Tempaltes" is enabled, Macro Security level is
"Medium".
Could it be something to do with .NET Framework security? Is the
add-in a
VSTO solution? I don't think so because the accompanying help file
makes
no
such reference.

Thanks for any assistance!

Regards,

Ian Digby

--
Work performed in the spirit of service is worship...Baha''''i
Writings