6 Messages
Digest #3763
1e
Re: RCHGetYahooQuotes stops working - here's a workaround [1 Attachm by "Randy Harmelink" rharmelink
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?
>
>
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...
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(
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...
>
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 "RCHGetYahooQu
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(
> 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" 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
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"
I didn't need to use the "smfFixLinks&q
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:
Posting Komentar