Add-in functions not available

[Ian Digby]

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

 

[Bob Phillips]

Did you actually check it in the Tools>Addins dialog?

--
HTH

Bob Phillips

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

 

[Ian Digby]

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

 

[Bob Phillips]

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)