4 Messages
Digest #4658
Messages
Sat Dec 7, 2019 6:53 am (PST) . Posted by:
"TN Bayless" tnbayless
Hi Randy, here is the latest:
Deselected "Ask to update automatic links" in the Generalsection
Downloaded fresh copy of smfGetYahooPortfolioView-Example
Open file/Excel
Warning box appears "This workbook contains link to one ormore external "
Click "Don't update" on warning box
Cell D5 shows:
='C:\SMFAdd-in\RCH_Stock_Market_Functions.xla'!smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
Run smfFixLinks
Cell D5 shows:
=RCH_Stock_Market_Functions.xla!smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
Move from D5 to D6 back to D5, D5 shows:
=smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
Save file, exit Excel
Reopen file/Excel
Get warning message, select "update links"
Contents of cell D5:
='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
So it appears that Excel is not remembering that the link has been fixed. . . .
On Saturday, December 7, 2019, 12:50:02 AM CST, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
My option is selected.
I think the reason you're getting the contents of the cell that I said should be impossible is that you've told EXCEL to update automatic links as it sees fit, and it's not doing them properly.
That "warning message" you used to get was basically telling you that you needed to fix something -- unresolved links for add-in references. That's why I wrote the smfFixLinks macro -- because the typical EXCEL process of fixing unresolved links was unreliable when those links were for the add-in. And it appears having EXCEL do it automatically is just as screwy.
When the warning message comes up, I tell EXCEL to leave the unresolved links as they are and run the smfFixLinks macro.
On Fri, Dec 6, 2019 at 5:35 PM TN Bayless tnbayless@..
There are no warning message when the sheet is first opened.There used to be one, but it was fixed by deselecting the: "Ask to update automaticlinks" in the General section
#yiv9154568018 #yiv9154568018 -- #yiv9154568018ygrp-
Sat Dec 7, 2019 8:41 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The only way that makes sense to me is if your activated add-in is not
located at "C:\SMF Add-in\"
On Sat, Dec 7, 2019 at 7:53 AM TN Bayless tnbayless@... wrote:
> Hi Randy, here is the latest:
>
> Deselected "Ask to update automatic links" in the General section
>
> Downloaded fresh copy of smfGetYahooPortfolioView-Example
>
> Open file/Excel
>
> Warning box appears "This workbook contains link to one or more external "
>
> Click "Don't update" on warning box
>
> Cell D5 shows:
>
> ='C:\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
>
>
>
> Run smfFixLinks
>
>
>
> Cell D5 shows:
>
>
>
>
> =RCH_Stock_Market_Functions.xla!smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
>
>
>
> Move from D5 to D6 back to D5, D5 shows:
>
>
>
> =smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
>
>
>
> Save file, exit Excel
>
>
>
> Reopen file/Excel
>
>
>
> Get warning message, select "update links"
>
>
>
> Contents of cell D5:
>
> ='C:\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
>
> So it appears that Excel is not remembering that the link has been fixed.
> . . .
>
>
located at "C:\
On Sat, Dec 7, 2019 at 7:53 AM TN Bayless tnbayless@..
> Hi Randy, here is the latest:
>
> Deselected "Ask to update automatic links" in the General section
>
> Downloaded fresh copy of smfGetYahooPortfoli
>
> Open file/Excel
>
> Warning box appears "This workbook contains link to one or more external "
>
> Click "Don't update" on warning box
>
> Cell D5 shows:
>
> ='C:\
> Add-in\RCH_
>
>
>
> Run smfFixLinks
>
>
>
> Cell D5 shows:
>
>
>
>
> =RCH_Stock_Market_
>
>
>
> Move from D5 to D6 back to D5, D5 shows:
>
>
>
> =smfGetYahooPortfol
>
>
>
> Save file, exit Excel
>
>
>
> Reopen file/Excel
>
>
>
> Get warning message, select "update links"
>
>
>
> Contents of cell D5:
>
> ='C:\
> Add-in\RCH_
>
> So it appears that Excel is not remembering that the link has been fixed.
> . . .
>
>
Sat Dec 7, 2019 8:49 am (PST) . Posted by:
"TN Bayless" tnbayless
Hi Randy, here is a screenshot of where the add-in is located
On Saturday, December 7, 2019, 10:42:39 AM CST, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
The only way that makes sense to me is if your activated add-in is not located at "C:\SMFAdd-in\"
On Sat, Dec 7, 2019 at 7:53 AM TN Bayless tnbayless@... wrote:
Hi Randy, here is the latest:
Deselected "Ask to update automatic links" in the Generalsection
Downloaded fresh copy of smfGetYahooPortfolioView-Example
Open file/Excel
Warning box appears "This workbook contains link to one ormore external "
Click "Don't update" on warning box
Cell D5 shows:
='C:\SMFAdd-in\RCH_Stock_Market_Functions..xla'!smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
Run smfFixLinks
Cell D5 shows:
=RCH_Stock_Market_Functions.xla!smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
Move from D5 to D6 back to D5, D5 shows:
=smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
Save file, exit Excel
Reopen file/Excel
Get warning message, select "update links"
Contents of cell D5:
='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
So it appears that Excel is not remembering that the link has been fixed. . . .
#yiv2556944211 #yiv2556944211 -- #yiv2556944211ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2556944211 #yiv2556944211ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2556944211 #yiv2556944211ygrp-mkp #yiv2556944211hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2556944211 #yiv2556944211ygrp-mkp #yiv2556944211ads {margin-bottom:10px;}#yiv2556944211 #yiv2556944211ygrp-mkp .yiv2556944211ad {padding:0 0;}#yiv2556944211 #yiv2556944211ygrp-mkp .yiv2556944211ad p {margin:0;}#yiv2556944211 #yiv2556944211ygrp-mkp .yiv2556944211ad a {color:#0000ff;text-decoration:none;}#yiv2556944211 #yiv2556944211ygrp-sponsor #yiv2556944211ygrp-lc {font-family:Arial;}#yiv2556944211 #yiv2556944211ygrp-sponsor #yiv2556944211ygrp-lc #yiv2556944211hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2556944211 #yiv2556944211ygrp-sponsor #yiv2556944211ygrp-lc .yiv2556944211ad {margin-bottom:10px;padding:0 0;}#yiv2556944211 #yiv2556944211actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2556944211 #yiv2556944211activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2556944211 #yiv2556944211activity span {font-weight:700;}#yiv2556944211 #yiv2556944211activity span:first-child {text-transform:uppercase;}#yiv2556944211 #yiv2556944211activity span a {color:#5085b6;text-decoration:none;}#yiv2556944211 #yiv2556944211activity span span {color:#ff7900;}#yiv2556944211 #yiv2556944211activity span .yiv2556944211underline {text-decoration:underline;}#yiv2556944211 .yiv2556944211attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2556944211 .yiv2556944211attach div a {text-decoration:none;}#yiv2556944211 .yiv2556944211attach img {border:none;padding-right:5px;}#yiv2556944211 .yiv2556944211attach label {display:block;margin-bottom:5px;}#yiv2556944211 .yiv2556944211attach label a {text-decoration:none;}#yiv2556944211 blockquote {margin:0 0 0 4px;}#yiv2556944211 .yiv2556944211bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2556944211 .yiv2556944211bold a {text-decoration:none;}#yiv2556944211 dd.yiv2556944211last p a {font-family:Verdana;font-weight:700;}#yiv2556944211 dd.yiv2556944211last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2556944211 dd.yiv2556944211last p span.yiv2556944211yshortcuts {margin-right:0;}#yiv2556944211 div.yiv2556944211attach-table div div a {text-decoration:none;}#yiv2556944211 div.yiv2556944211attach-table {width:400px;}#yiv2556944211 div.yiv2556944211file-title a, #yiv2556944211 div.yiv2556944211file-title a:active, #yiv2556944211 div.yiv2556944211file-title a:hover, #yiv2556944211 div.yiv2556944211file-title a:visited {text-decoration:none;}#yiv2556944211 div.yiv2556944211photo-title a, #yiv2556944211 div.yiv2556944211photo-title a:active, #yiv2556944211 div.yiv2556944211photo-title a:hover, #yiv2556944211 div.yiv2556944211photo-title a:visited {text-decoration:none;}#yiv2556944211 div#yiv2556944211ygrp-mlmsg #yiv2556944211ygrp-msg p a span.yiv2556944211yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2556944211 .yiv2556944211green {color:#628c2a;}#yiv2556944211 .yiv2556944211MsoNormal {margin:0 0 0 0;}#yiv2556944211 o {font-size:0;}#yiv2556944211 #yiv2556944211photos div {float:left;width:72px;}#yiv2556944211 #yiv2556944211photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2556944211 #yiv2556944211photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2556944211 #yiv2556944211reco-category {font-size:77%;}#yiv2556944211 #yiv2556944211reco-desc {font-size:77%;}#yiv2556944211 .yiv2556944211replbq {margin:4px;}#yiv2556944211 #yiv2556944211ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2556944211 #yiv2556944211ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2556944211 #yiv2556944211ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2556944211 #yiv2556944211ygrp-mlmsg select, #yiv2556944211 input, #yiv2556944211 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2556944211 #yiv2556944211ygrp-mlmsg pre, #yiv2556944211 code {font:115% monospace;}#yiv2556944211 #yiv2556944211ygrp-mlmsg * {line-height:1.22em;}#yiv2556944211 #yiv2556944211ygrp-mlmsg #yiv2556944211logo {padding-bottom:10px;}#yiv2556944211 #yiv2556944211ygrp-msg p a {font-family:Verdana;}#yiv2556944211 #yiv2556944211ygrp-msg p#yiv2556944211attach-count span {color:#1E66AE;font-weight:700;}#yiv2556944211 #yiv2556944211ygrp-reco #yiv2556944211reco-head {color:#ff7900;font-weight:700;}#yiv2556944211 #yiv2556944211ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2556944211 #yiv2556944211ygrp-sponsor #yiv2556944211ov li a {font-size:130%;text-decoration:none;}#yiv2556944211 #yiv2556944211ygrp-sponsor #yiv2556944211ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2556944211 #yiv2556944211ygrp-sponsor #yiv2556944211ov ul {margin:0;padding:
On Saturday, December 7, 2019, 10:42:39 AM CST, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
The only way that makes sense to me is if your activated add-in is not located at "C:\
On Sat, Dec 7, 2019 at 7:53 AM TN Bayless tnbayless@..
Hi Randy, here is the latest:
Deselected "Ask to update automatic links" in the Generalsection
Downloaded fresh copy of smfGetYahooPortfoli
Open file/Excel
Warning box appears "This workbook contains link to one ormore external "
Click "Don't update" on warning box
Cell D5 shows:
='C:\
Run smfFixLinks
Cell D5 shows:
=RCH_Stock_Market_
Move from D5 to D6 back to D5, D5 shows:
=smfGetYahooPortfol
Save file, exit Excel
Reopen file/Excel
Get warning message, select "update links"
Contents of cell D5:
='C:\
So it appears that Excel is not remembering that the link has been fixed. . . .
#yiv2556944211 #yiv2556944211 -- #yiv2556944211ygrp-