If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
linking names with functions | Alex | Database Design | 1 | February 5th, 2006 12:23 AM |
Database functions should use criteria in formula, as 1-2-3 does | 123user | Worksheet Functions | 8 | September 29th, 2005 08:57 PM |
Visible rows and functions that work | tracy | Worksheet Functions | 2 | August 19th, 2005 05:25 AM |
Workbook with big array functions slow to open first time in 2003 | Terry | General Discussion | 1 | September 2nd, 2004 05:00 PM |
Pointless rant about order of terms in functions | Pete McCosh | Worksheet Functions | 8 | March 17th, 2004 04:37 PM |