Senin, 08 Agustus 2016

[smf_addin] Digest Number 3763[1 Attachment]

6 Messages

Digest #3763

Messages

Sun Aug 7, 2016 9:30 pm (PDT) . Posted by:

jpaulaustin

I'm getting #NAME? for all my links now and have the add-in stored in a custom location. Any other ideas?

Sun Aug 7, 2016 9:36 pm (PDT) . Posted by:

jpaulaustin

Looks like the trick someone mentioned about the unchecking the Add-In (then you have to get out of that Add-In page), then returning to options and reselecting the Add-In fixed my #NAME? problem.

Mon Aug 8, 2016 12:00 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

​​
This has been discussed in a number of message threads recently. The
problem appears to be related to a recent MicroSoft security update. It's
not letting EXCEL load the add-in when EXCEL starts up. As a result, you
are getting link errors, because EXCEL can't resolve the links to the
add-in.

For a workaround suggested by Microsoft, until they fix the issue, see:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568

On Sun, Aug 7, 2016 at 9:30 PM, paul@
​...wrote:

>
> I'm getting #NAME? for all my links now and have the add-in stored in a
> custom location. Any other ideas?
>
>

Mon Aug 8, 2016 12:57 am (PDT) . Posted by:

dnunn0

Sadly, this doesn't seem to work for Excel 2007 on Windows 10 (or at least, not mine).

I tried both unblocking and adding the location to the trust center (and unchecking/checking in the Add-ins list).

The version function works, but not something simple like
=RCHGetYahooQuotes("IBM")
That returns "#VALUE".

Maybe it's time to upgrade...
Attachment(s) from
1 of 1 File(s)

Mon Aug 8, 2016 1:56 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

If the "Version" function works, the add-in is up and running. What results
did you get? Your uploaded file works fine here, but it's using my add-in,
not yours.

Usually, the #VALUE result like that means an invalid parameter type was
passed to the function, but it looks fine to me.

Hmmm. I tried to cut and paste your formula below. EXCEL wouldn't let me
enter it. Told me the function was wrong. You have three strange characters
between the "=" and the "RCHGetYahooQuotes"...

On Mon, Aug 8, 2016 at 12:57 AM, dnunn0@
​...wrote:

>
> Sadly, this doesn't seem to work for Excel 2007 on Windows 10 (or at
> least, not mine).
>
> I tried both unblocking and adding the location to the trust center (and
> unchecking/checking in the Add-ins list).
>
> The version function works, but not something simple like
>
> ​​
> =
> ​​
> RCHGetYahooQuotes("IBM")
> That returns "#VALUE".
>
> Maybe it's time to upgrade...
>

Sun Aug 7, 2016 11:03 pm (PDT) . Posted by:

johneknudson

I've been having to reload the Add-in for about a month (had a full computer rebuild, sigh) and finally got time to work the issue this morning. After the rebuild I simply followed the standard instructions: http://ogres-crypt.com/SMF/Install-the-addin.html http://ogres-crypt.com/SMF/Install-the-addin.html but would have to reload the add-in every time I started my spreadsheets using the function.


From other conversations here I gleaned the following two corrections;


Go to the SMF Add-in folder, right click each file, select properties, click "unblock". In Excel > File to get backstage > Excel Options > Trust Center > Trust Center Settings > Add the SMF Add-in folder.

I didn't need to use the "smfFixLinks&quot; macro, but for those unfamiliar, an <alt-F8> will open the macro function where you can type in that command in a excel book with the SMF add-in working.


It is working for me now. I'll add my praises to Randy for the excellent tool (and consider how I can pay it forward!). Regards, -Ted
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar