Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
> </o
>
I have a spreadsheet that uses a number of public functions from an add-in in cell formulas. These same public functions are also called in the macros of the spreadsheet and so the add-in is referenced in the spreadsheet code.<o
></o
>
<o
> </o
>
If the following situation occurs, then the spreadsheet cells that use the public functions all appear “#NAME?”:<o
></o
>
<o
> </o
>
> </o
>
If the user does not tick the add-in in the add-in manager, but macros are disabled with notification, the #NAME? error does not occur.<o
></o
>
If the user has the add-in ticked but macro settings are set to enabled the #NAME? error does not occur.<o
></o
>
In order to get the cells using the public functions to calculate when the #NAME? error occurs, the user has to enter each cell and hit return.<o
></o
>
<o
> </o
>
An easy solution would be for users not to have the add-ins ticked. However, this isn’t an ideal or practical solution as other spreadsheets use these add-ins and there is a global policy to have these ticked.<o
></o
>
<o
> </o
>
Do you know why having an add-in ticked and referenced causes this issue? How we can fix this please?<o
></o
>
<o
> </o
>
The <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com
ffice:smarttags" /><st1
lace w:st="on"><st1:PlaceName w:st="on">Trust</st1:PlaceName> <st1:PlaceType w:st="on">Center</st1:PlaceType></st1
lace> settings are such that spreadsheets on our network should be Trusted Documents. But it appears Excel does not recognise the spreadsheet as trusted until the second time it is opened. <o
></o
>
<o
> </o
>
Again an easy solution would be to list our network drive in the trusted documents location but I thought that the “Trust all documents on network” tick box would do this automatically.<o
></o
>
<o
> </o
>
Has anyone else come across this before?<o
></o
>
<o
> </o
>
<o
> </o
>
I am using 32 Bit Excel 2010. <o
></o
>
I do not have the same issue opening the same spreadsheet saved as a .xls file in 2003. <o
></o
>
I do not have the same issue opening the same spreadsheet saved as a .xls file in 2003 but opened in compatibility mode in 2010.<o
></o
>
<o
> </o
>
Thanks<o
></o
>




<o


I have a spreadsheet that uses a number of public functions from an add-in in cell formulas. These same public functions are also called in the macros of the spreadsheet and so the add-in is referenced in the spreadsheet code.<o


<o


If the following situation occurs, then the spreadsheet cells that use the public functions all appear “#NAME?”:<o


<o


- The referenced add-in is also ticked by the spreadsheet user in the add-in manager; <o
></o
>
- Macro settings are set to “Disable all macros with notification” (and the user selects to enable content); and <o
></o
>
- This spreadsheet is not a “Trusted” document (i.e. the enable content option is displayed on opening and not automatically accepted) <o
></o
>


If the user does not tick the add-in in the add-in manager, but macros are disabled with notification, the #NAME? error does not occur.<o


If the user has the add-in ticked but macro settings are set to enabled the #NAME? error does not occur.<o


In order to get the cells using the public functions to calculate when the #NAME? error occurs, the user has to enter each cell and hit return.<o


<o


An easy solution would be for users not to have the add-ins ticked. However, this isn’t an ideal or practical solution as other spreadsheets use these add-ins and there is a global policy to have these ticked.<o


<o


Do you know why having an add-in ticked and referenced causes this issue? How we can fix this please?<o


<o


The <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com





<o


Again an easy solution would be to list our network drive in the trusted documents location but I thought that the “Trust all documents on network” tick box would do this automatically.<o


<o


Has anyone else come across this before?<o


<o


<o


I am using 32 Bit Excel 2010. <o


I do not have the same issue opening the same spreadsheet saved as a .xls file in 2003. <o


I do not have the same issue opening the same spreadsheet saved as a .xls file in 2003 but opened in compatibility mode in 2010.<o


<o


Thanks<o

