Kamis, 28 Juli 2016

[smf_addin] Digest Number 3756[1 Attachment]

9 Messages

Digest #3756

Messages

Wed Jul 27, 2016 10:33 am (PDT) . Posted by:

"Jose Jacob" pepecan47

It was a recent thread similar to my situation, but I am not sure if there is a resolution.

All of a sudden my spreadsheets that use the SMF are not working.

When I open the spreadsheet I've got a message from Microsoft Excel : "The workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have."
The are in the message 3 push buttons: Update, Don' update, Help.

The values in the spreadsheet are not updated. If I enter Update or Don't update nothing happens.

If I enter a different Ticker, all cells in the spreadsheet have "#NAME?".

The formula for a cell for the Share price shows

='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A$2,"l1")

I don't know why is inserting 'C:\SMF Add-In\RCH_Stock_Market_Functions.xla'! in the formula.

Regards,
Jose L. Jacob

Wed Jul 27, 2016 1:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

This has been discussed in a few message threads already. 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.

The path to the add-in was inserted into your formula when EXCEL saved the
workbook. EXCEL does that automatically. When it later opens the workbook
and can't resolve the link, it tags it as an unresolved link and leaves
that path on the formula.

I don't have a solution to return things to the way they before. One person
says they load EXCEL, then go into the add-in manager and checks and
unchecks the add-in.

In an individual workbook, click on the "Don't Update" box when the error
message comes up. After the workbook is loaded and the add-in is
"connected" via the add-in manager, run the smfFixLinks macro to fix the
unresolved links.

One thing that occurred to me last night, that I haven't had anyone try yet
-- add the SMF folder as a "Trusted Location" in your EXCEL security
settings. Previously, when you installed an add-in, it WAS considered
trusted. Not sure if that will help or not.

On Wed, Jul 27, 2016 at 10:33 AM, Jose Jacob pepecan47@
​...wrote:

> It was a recent thread similar to my situation, but I am not sure if there
> is a resolution.
>
> All of a sudden my spreadsheets that use the SMF are not working.
>
> When I open the spreadsheet I've got a message from Microsoft Excel : "The
> workbook contains links to one or more external sources that could be
> unsafe. If you trust the links, update them to get the latest data.
> Otherwise, you can keep working with the data you have."
> The are in the message 3 push buttons: Update, Don' update, Help.
>
> The values in the spreadsheet are not updated. If I enter Update or Don't
> update nothing happens.
>
> If I enter a different Ticker, all cells in the spreadsheet have "#NAME?".
>
> The formula for a cell for the Share price shows
>
> ='C:\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A$2,"l1")
>
> I don't know why is inserting 'C:\SMF
> Add-In\RCH_Stock_Market_Functions.xla'! in the formula.
>

Thu Jul 28, 2016 12:12 am (PDT) . Posted by:

"V. Shankar" tarakayan

Yes...this happened to me y'day.  I tried reloading the add-in again.  It started working.
Reporting issues like this here is very helpful.
thanks

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, July 28, 2016 2:05 AM
Subject: Re: [smf_addin] Microsoft Excel security message

  This has been discussed in a few message threads already. 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.

The path to the add-in was inserted into your formula when EXCEL saved the workbook. EXCEL does that automatically. When it later opens the workbook and can't resolve the link, it tags it as an unresolved link and leaves that path on the formula.

I don't have a solution to return things to the way they before. One person says they load EXCEL, then go into the add-in manager and checks and unchecks the add-in.

In an individual workbook, click on the "Don't Update" box when the error message comes up. After the workbook is loaded and the add-in is "connected&quot; via the add-in manager, run the smfFixLinks macro to fix the unresolved links.

One thing that occurred to me last night, that I haven't had anyone try yet -- add the SMF folder as a "Trusted Location" in your EXCEL security settings. Previously, when you installed an add-in, it WAS considered trusted. Not sure if that will help or not.

On Wed, Jul 27, 2016 at 10:33 AM, Jose Jacob pepecan47@​...wrote:

It was a recent thread similar to my situation, but I am not sure if there is a resolution.

All of a sudden my spreadsheets that use the SMF are not working.

When I open the spreadsheet I've got a message from Microsoft Excel : "The workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have."
The are in the message 3 push buttons: Update, Don' update, Help.

The values in the spreadsheet are not updated. If I enter Update or Don't update nothing happens.

If I enter a different Ticker, all cells in the spreadsheet have "#NAME?".

The formula for a cell for the Share price shows

='C:\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes($A$2,"l1")

I don't know why is inserting 'C:\SMF Add-In\RCH_Stock_Market_Functions.xla'! in the formula.

#yiv5518339069 #yiv5518339069 -- #yiv5518339069ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5518339069 #yiv5518339069ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5518339069 #yiv5518339069ygrp-mkp #yiv5518339069hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5518339069 #yiv5518339069ygrp-mkp #yiv5518339069ads {margin-bottom:10px;}#yiv5518339069 #yiv5518339069ygrp-mkp .yiv5518339069ad {padding:0 0;}#yiv5518339069 #yiv5518339069ygrp-mkp .yiv5518339069ad p {margin:0;}#yiv5518339069 #yiv5518339069ygrp-mkp .yiv5518339069ad a {color:#0000ff;text-decoration:none;}#yiv5518339069 #yiv5518339069ygrp-sponsor #yiv5518339069ygrp-lc {font-family:Arial;}#yiv5518339069 #yiv5518339069ygrp-sponsor #yiv5518339069ygrp-lc #yiv5518339069hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5518339069 #yiv5518339069ygrp-sponsor #yiv5518339069ygrp-lc .yiv5518339069ad {margin-bottom:10px;padding:0 0;}#yiv5518339069 #yiv5518339069actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5518339069 #yiv5518339069activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5518339069 #yiv5518339069activity span {font-weight:700;}#yiv5518339069 #yiv5518339069activity span:first-child {text-transform:uppercase;}#yiv5518339069 #yiv5518339069activity span a {color:#5085b6;text-decoration:none;}#yiv5518339069 #yiv5518339069activity span span {color:#ff7900;}#yiv5518339069 #yiv5518339069activity span .yiv5518339069underline {text-decoration:underline;}#yiv5518339069 .yiv5518339069attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5518339069 .yiv5518339069attach div a {text-decoration:none;}#yiv5518339069 .yiv5518339069attach img {border:none;padding-right:5px;}#yiv5518339069 .yiv5518339069attach label {display:block;margin-bottom:5px;}#yiv5518339069 .yiv5518339069attach label a {text-decoration:none;}#yiv5518339069 blockquote {margin:0 0 0 4px;}#yiv5518339069 .yiv5518339069bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5518339069 .yiv5518339069bold a {text-decoration:none;}#yiv5518339069 dd.yiv5518339069last p a {font-family:Verdana;font-weight:700;}#yiv5518339069 dd.yiv5518339069last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5518339069 dd.yiv5518339069last p span.yiv5518339069yshortcuts {margin-right:0;}#yiv5518339069 div.yiv5518339069attach-table div div a {text-decoration:none;}#yiv5518339069 div.yiv5518339069attach-table {width:400px;}#yiv5518339069 div.yiv5518339069file-title a, #yiv5518339069 div.yiv5518339069file-title a:active, #yiv5518339069 div.yiv5518339069file-title a:hover, #yiv5518339069 div.yiv5518339069file-title a:visited {text-decoration:none;}#yiv5518339069 div.yiv5518339069photo-title a, #yiv5518339069 div.yiv5518339069photo-title a:active, #yiv5518339069 div.yiv5518339069photo-title a:hover, #yiv5518339069 div.yiv5518339069photo-title a:visited {text-decoration:none;}#yiv5518339069 div#yiv5518339069ygrp-mlmsg #yiv5518339069ygrp-msg p a span.yiv5518339069yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5518339069 .yiv5518339069green {color:#628c2a;}#yiv5518339069 .yiv5518339069MsoNormal {margin:0 0 0 0;}#yiv5518339069 o {font-size:0;}#yiv5518339069 #yiv5518339069photos div {float:left;width:72px;}#yiv5518339069 #yiv5518339069photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5518339069 #yiv5518339069photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5518339069 #yiv5518339069reco-category {font-size:77%;}#yiv5518339069 #yiv5518339069reco-desc {font-size:77%;}#yiv5518339069 .yiv5518339069replbq {margin:4px;}#yiv5518339069 #yiv5518339069ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5518339069 #yiv5518339069ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5518339069 #yiv5518339069ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5518339069 #yiv5518339069ygrp-mlmsg select, #yiv5518339069 input, #yiv5518339069 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5518339069 #yiv5518339069ygrp-mlmsg pre, #yiv5518339069 code {font:115% monospace;}#yiv5518339069 #yiv5518339069ygrp-mlmsg * {line-height:1.22em;}#yiv5518339069 #yiv5518339069ygrp-mlmsg #yiv5518339069logo {padding-bottom:10px;}#yiv5518339069 #yiv5518339069ygrp-msg p a {font-family:Verdana;}#yiv5518339069 #yiv5518339069ygrp-msg p#yiv5518339069attach-count span {color:#1E66AE;font-weight:700;}#yiv5518339069 #yiv5518339069ygrp-reco #yiv5518339069reco-head {color:#ff7900;font-weight:700;}#yiv5518339069 #yiv5518339069ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5518339069 #yiv5518339069ygrp-sponsor #yiv5518339069ov li a {font-size:130%;text-decoration:none;}#yiv5518339069 #yiv5518339069ygrp-sponsor #yiv5518339069ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5518339069 #yiv5518339069ygrp-sponsor #yiv5518339069ov ul {margin:0;padding:0 0 0 8px;}#yiv5518339069 #yiv5518339069ygrp-text {font-family:Georgia;}#yiv5518339069 #yiv5518339069ygrp-text p {margin:0 0 1em 0;}#yiv5518339069 #yiv5518339069ygrp-text tt {font-size:120%;}#yiv5518339069 #yiv5518339069ygrp-vital ul li:last-child {border-right:none !important;}#yiv5518339069

Thu Jul 28, 2016 12:35 am (PDT) . Posted by:

perseuslim11

Randy, I've just tried adding the C\smf as trusted location and it worked like a charm!

Thanks Randy again ^_^

Wed Jul 27, 2016 6:16 pm (PDT) . Posted by:

"Gaston Bullrich" gbullr

Worked great.

Having problem importing this web site:
http://www.investing.com/rates-bonds/world-government-bonds

Any suggestions?

On Wed, Jul 27, 2016 at 1:01 AM, Gaston Bullrich <gaston.bullrich@gmail.com>
wrote:

> Thanks Randy. Will try tomorrow AM.
>
> All the best.
>
>
>
> On Wed, Jul 27, 2016 at 12:52 AM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> Try either of:
>>
>> =RCHGetHTMLTable("http://finance.yahoo.com/quote/MSFT/holders","Top
>> Institutional Holders",1,"",2)
>> =RCHGetHTMLTable("http://finance.yahoo.com/quote/MSFT/holders","Top
>> Institutional Holders",1,"Top Mutual Fund Holders",1)
>>
>> "Top Institutional Holders" is actually OUTSIDE the table, so the
>> directional item(s) need to go to the NEXT table(s).
>>
>> The "Name" result you were getting is from the previous table. It sounds
>> like you entered the formula into a single cell. You need to array-enter it
>> over a range if you want all the data in the table. An EXCEL function can
>> only return data into cells it's given permission to do so.
>>
>>
>> On Tue, Jul 26, 2016 at 8:22 PM, gaston.bullrich@
>> ​...wrote:
>>
>>> Trying to get Top Institutional holders and Mutual fund holders found
>>> here:
>>>
>>> http://finance.yahoo.com/quote/MSFT/holders?ltr=1
>>>
>>> with following cell in a7 for top institutional holders. a4 is the link
>>> above.
>>>
>>> =rchgethtmltable(A4,"Top Institutional Holders",-1,"Top Mutual Fund
>>> Holders",1)
>>>
>>> Changing the -1, 1 above does notthing . No matter what I put in there
>>> formula output is Name.
>>>
>>>
>>
>>
>
>
>
> --
> Gaston Bullrich
> 20 East 67th Street Apt 2F
> New York, NY 10065
> Cel. 917 517 9907
>

--
Gaston Bullrich
20 East 67th Street Apt 2F
New York, NY 10065
Cel. 917 517 9907

Wed Jul 27, 2016 6:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The only unique thing I could find to identify a table is a label within
the table. For example:

=RCHGetHTMLTable("
http://www.investing.com/rates-bonds/world-government-bonds","Bulgaria 1M")

On Wed, Jul 27, 2016 at 6:15 PM, Gaston Bullrich gaston.bullrich@
​... wrote:

>
> Having problem importing this web site:
> http://www.investing.com/rates-bonds/world-government-bonds
>
> Any suggestions?
>
>

Wed Jul 27, 2016 10:56 pm (PDT) . Posted by:

perseuslim11

Randy, I hv this weird error that makes the template all go into error coz unable to use the addin, shown in the photo below:

it only happened after i reformatted my pc.
I had backup a copy of my template to my googledrive before reformmatting the pc


then after reformatting, I installed the smf addin to my C:\SMF Add-In


but there's an error as shown in the photo, may I know how to fix this error?


Thanks ^_^
Attachment(s) from
1 of 1 Photo(s)

Wed Jul 27, 2016 11:12 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30549

On Wed, Jul 27, 2016 at 10:56 PM, perseuslim11@
​...wrote:

>
> Randy, I hv this weird error that makes the template all go into error coz
> unable to use the addin, shown in the photo below:
>
> it only happened after i reformatted my pc.
> I had backup a copy of my template to my googledrive before reformmatting
> the pc
>
> then after reformatting, I installed the smf addin to my C:\SMF Add-In
>
> but there's an error as shown in the photo, may I know how to fix this
> error?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar