Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add-in functions not available
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add-in functions not available
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add-in functions not available
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions |