Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><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-comffice:smarttags" /><st1lace w:st="on"><st1:PlaceName w:st="on">Trust</st1:PlaceName> <st1:PlaceType w:st="on">Center</st1:PlaceType></st1lace> 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>
fficeffice" /><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>- 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>
> </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" /><st1lace w:st="on"><st1:PlaceName w:st="on">Trust</st1:PlaceName> <st1:PlaceType w:st="on">Center</st1:PlaceType></st1lace> 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>
