4 Messages
Digest #4656
Messages
Thu Dec 5, 2019 6:44 pm (PST) . Posted by:
"TN Bayless" tnbayless
I am having the same problem as another SMF user had recently. On a Win10Pro/Excel2013 box, I am having to deselect/reselect. the addin every time I open the worksheet. I have tried many things including running the smfFixLinks macro, which will activate the plugin for that session only.. When you save the worksheet and reopen it, the links are broken again. I tried "unblock" on the general tab and it made no difference. I tried adding the SMF folder to the trusted zone and it appears to have made no difference. Turned off virus protection, also no difference. Enabled all external content in the Trust Center= no difference. I did a "reset options" reinstall on the entire Office 2013 Suite and it made no difference. I am not sure what that really accomplished since the spreadsheet still had the SMF addin attached, so it is not clear what MS means when they supposedly reset to original defaults. I tried changing the folder holding the plugin and that also did not work, it just created false errors that the spreadsheet seemed to remember.
The only thing that worked was a did a fresh Win10Pro/Excel 2013 on a different box on it worked perfectly. Short of a clean install on my main box, I am out of ideas.
Any thoughts?
Thanks
The only thing that worked was a did a fresh Win10Pro/Excel 2013 on a different box on it worked perfectly. Short of a clean install on my main box, I am out of ideas.
Any thoughts?
Thanks
Thu Dec 5, 2019 6:59 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but that doesn't make sense to me.
If you can run smfFixLinks, then the add-in is available.
If you close and restart EXCEL, what does this formula give you in a new
worksheet:
=RCHGetElementNumber("Version")
On Thu, Dec 5, 2019 at 7:44 PM TN Bayless tnbayless@... wrote:
>
> I am having the same problem as another SMF user had recently. On a
> Win10Pro/Excel2013 box, I am having to deselect/reselect. the addin every
> time I open the worksheet. I have tried many things including running the
> smfFixLinks macro, which will activate the plugin for that session only.
> When you save the worksheet and reopen it, the links are broken again. I
> tried "unblock" on the general tab and it made no difference.. I tried
> adding the SMF folder to the trusted zone and it appears to have made no
> difference. Turned off virus protection, also no difference. Enabled all
> external content in the Trust Center= no difference. I did a "reset
> options" reinstall on the entire Office 2013 Suite and it made no
> difference. I am not sure what that really accomplished since the
> spreadsheet still had the SMF addin attached, so it is not clear what MS
> means when they supposedly reset to original defaults. I tried changing the
> folder holding the plugin and that also did not work, it just created false
> errors that the spreadsheet seemed to remember.
>
> The only thing that worked was a did a fresh Win10Pro/Excel 2013 on a
> different box on it worked perfectly. Short of a clean install on my main
> box, I am out of ideas.
>
> Any thoughts?
>
>
>
If you can run smfFixLinks, then the add-in is available.
If you close and restart EXCEL, what does this formula give you in a new
worksheet:
=RCHGetElementNumbe
On Thu, Dec 5, 2019 at 7:44 PM TN Bayless tnbayless@..
>
> I am having the same problem as another SMF user had recently. On a
> Win10Pro/Excel2013 box, I am having to deselect/reselect. the addin every
> time I open the worksheet. I have tried many things including running the
> smfFixLinks macro, which will activate the plugin for that session only.
> When you save the worksheet and reopen it, the links are broken again. I
> tried "unblock" on the general tab and it made no difference.. I tried
> adding the SMF folder to the trusted zone and it appears to have made no
> difference. Turned off virus protection, also no difference. Enabled all
> external content in the Trust Center= no difference. I did a "reset
> options" reinstall on the entire Office 2013 Suite and it made no
> difference. I am not sure what that really accomplished since the
> spreadsheet still had the SMF addin attached, so it is not clear what MS
> means when they supposedly reset to original defaults. I tried changing the
> folder holding the plugin and that also did not work, it just created false
> errors that the spreadsheet seemed to remember.
>
> The only thing that worked was a did a fresh Win10Pro/Excel 2013 on a
> different box on it worked perfectly. Short of a clean install on my main
> box, I am out of ideas.
>
> Any thoughts?
>
>
>
Thu Dec 5, 2019 8:56 pm (PST) . Posted by:
"TN Bayless" tnbayless
Hi Randy, instead of using my spreadsheet, I downloaded the smfGetPortfolioView-Example template. I changed the array formula to point to where I put the add in. The data section performs exactly the same as my spreadsheet. It updates the first time you open it, then you save it and re-open it does not update. When you run the smfFixLinks macro, the sheet does update again.
I added a separate tab just for the =RCHGetElementNumber("Version")
It replied with:
"Stock Market Functions add-in, Version 2.1.2018.01.24 (c:\Program Files (x86)\SMF_Add_in; Windows (64-bit) NT :.00; 15.0; ; ; 1)"
and did NOT change when the sheet was saved and re-opened.
Not sure what to make of it. . . .
Thanks
On Thursday, December 5, 2019, 09:01:44 PM CST, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Sorry, but that doesn't make sense to me.
If you can run smfFixLinks, then the add-in is available.
If you close and restart EXCEL, what does this formula give you in a new worksheet:
=RCHGetElementNumber("Version")
On Thu, Dec 5, 2019 at 7:44 PM TN Bayless tnbayless@... wrote:
I am having the same problem as another SMF user had recently. On a Win10Pro/Excel2013 box, I am having to deselect/reselect. the addin every time I open the worksheet. I have tried many things including running the smfFixLinks macro, which will activate the plugin for that session only. When you save the worksheet and reopen it, the links are broken again. I tried "unblock" on the general tab and it made no difference. I tried adding the SMF folder to the trusted zone and it appears to have made no difference.. Turned off virus protection, also no difference. Enabled all external content in the Trust Center= no difference. I did a "reset options" reinstall on the entire Office 2013 Suite and it made no difference. I am not sure what that really accomplished since the spreadsheet still had the SMF addin attached, so it is not clear what MS means when they supposedly reset to original defaults. I tried changing the folder holding the plugin and that also did not work, it just created false errors that the spreadsheet seemed to remember.
The only thing that worked was a did a fresh Win10Pro/Excel 2013 on a different box on it worked perfectly. Short of a clean install on my main box, I am out of ideas.
Any thoughts?
#yiv7121848035 #yiv7121848035 -- #yiv7121848035ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7121848035 #yiv7121848035ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7121848035 #yiv7121848035ygrp-mkp #yiv7121848035hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7121848035 #yiv7121848035ygrp-mkp #yiv7121848035ads {margin-bottom:10px;}#yiv7121848035 #yiv7121848035ygrp-mkp .yiv7121848035ad {padding:0 0;}#yiv7121848035 #yiv7121848035ygrp-mkp .yiv7121848035ad p {margin:0;}#yiv7121848035 #yiv7121848035ygrp-mkp .yiv7121848035ad a {color:#0000ff;text-decoration:none;}#yiv7121848035 #yiv7121848035ygrp-sponsor #yiv7121848035ygrp-lc {font-family:Arial;}#yiv7121848035 #yiv7121848035ygrp-sponsor #yiv7121848035ygrp-lc #yiv7121848035hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7121848035 #yiv7121848035ygrp-sponsor #yiv7121848035ygrp-lc .yiv7121848035ad {margin-bottom:10px;padding:0 0;}#yiv7121848035 #yiv7121848035actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7121848035 #yiv7121848035activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7121848035 #yiv7121848035activity span {font-weight:700;}#yiv7121848035 #yiv7121848035activity span:first-child {text-transform:uppercase;}#yiv7121848035 #yiv7121848035activity span a {color:#5085b6;text-decoration:none;}#yiv7121848035 #yiv7121848035activity span span {color:#ff7900;}#yiv7121848035 #yiv7121848035activity span .yiv7121848035underline {text-decoration:underline;}#yiv7121848035 .yiv7121848035attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7121848035 .yiv7121848035attach div a {text-decoration:none;}#yiv7121848035 .yiv7121848035attach img {border:none;padding-right:5px;}#yiv7121848035 .yiv7121848035attach label {display:block;margin-bottom:5px;}#yiv7121848035 .yiv7121848035attach label a {text-decoration:none;}#yiv7121848035 blockquote {margin:0 0 0 4px;}#yiv7121848035 .yiv7121848035bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7121848035 .yiv7121848035bold a {text-decoration:none;}#yiv7121848035 dd.yiv7121848035last p a {font-family:Verdana;font-weight:700;}#yiv7121848035 dd.yiv7121848035last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7121848035 dd.yiv7121848035last p span.yiv7121848035yshortcuts {margin-right:0;}#yiv7121848035 div.yiv7121848035attach-table div div a {text-decoration:none;}#yiv7121848035 div.yiv7121848035attach-table {width:400px;}#yiv7121848035 div.yiv7121848035file-title a, #yiv7121848035 div.yiv7121848035file-title a:active, #yiv7121848035 div.yiv7121848035file-title a:hover, #yiv7121848035 div.yiv7121848035file-title a:visited {text-decoration:none;}#yiv7121848035 div.yiv7121848035photo-title a, #yiv7121848035 div.yiv7121848035photo-title a:active, #yiv7121848035 div.yiv7121848035photo-title a:hover, #yiv7121848035 div.yiv7121848035photo-title a:visited {text-decoration:none;}#yiv7121848035 div#yiv7121848035ygrp-mlmsg #yiv7121848035ygrp-msg p a span.yiv7121848035yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7121848035 .yiv7121848035green {color:#628c2a;}#yiv7121848035 .yiv7121848035MsoNormal {margin:0 0 0 0;}#yiv7121848035 o {font-size:0;}#yiv7121848035 #yiv7121848035photos div {float:left;width:72px;}#yiv7121848035 #yiv7121848035photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7121848035 #yiv7121848035photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7121848035 #yiv7121848035reco-category {font-size:77%;}#yiv7121848035 #yiv7121848035reco-desc {font-size:77%;}#yiv7121848035 .yiv7121848035replbq {margin:4px;}#yiv7121848035 #yiv7121848035ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7121848035 #yiv7121848035ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7121848035 #yiv7121848035ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7121848035 #yiv7121848035ygrp-mlmsg select, #yiv7121848035 input, #yiv7121848035 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7121848035 #yiv7121848035ygrp-mlmsg pre, #yiv7121848035 code {font:115% monospace;}#yiv7121848035 #yiv7121848035ygrp-mlmsg * {line-height:1.22em;}#yiv7121848035 #yiv7121848035ygrp-mlmsg #yiv7121848035logo {padding-bottom:10px;}#yiv7121848035 #yiv7121848035ygrp-msg p a {font-family:Verdana;}#yiv7121848035 #yiv7121848035ygrp-msg p#yiv7121848035attach-count span {color:#1E66AE;font-weight:700;}#yiv7121848035 #yiv7121848035ygrp-reco #yiv7121848035reco-head {color:#ff7900;font-weight:700;}#yiv7121848035 #yiv7121848035ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7121848035 #yiv7121848035ygrp-sponsor #yiv7121848035ov li a {font-size:130%;text-decoration:none;}#yiv7121848035 #yiv7121848035ygrp-sponsor #yiv7121848035ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7121848035 #yiv7121848035ygrp-sponsor #yiv7121848035ov ul {margin:0;padding:0 0 0 8px;}#yiv7121848035 #yiv7121848035ygrp-text {font-family:Georgia;}#yiv7121848035 #yiv7121848035ygrp-text p {margin:0 0 1em 0;}#yiv7121848035 #yiv7121848035ygrp-text tt {font-size:120%;}#yiv7121848035 #yiv7121848035ygrp-vital ul li:last-child {border-right:none !important;}#yiv7121848035
I added a separate tab just for the =RCHGetElementNumber("Version")
It replied with:
"Stock Market Functions add-in, Version 2.1.2018.01.24 (c:\Program Files (x86)\SMF_Add_in; Windows (64-bit) NT :.00; 15.0; ; ; 1)"
and did NOT change when the sheet was saved and re-opened.
Not sure what to make of it. . . .
Thanks
On Thursday, December 5, 2019, 09:01:44 PM CST, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Sorry, but that doesn't make sense to me.
If you can run smfFixLinks, then the add-in is available.
If you close and restart EXCEL, what does this formula give you in a new worksheet:
=RCHGetElementNumbe
On Thu, Dec 5, 2019 at 7:44 PM TN Bayless tnbayless@..
I am having the same problem as another SMF user had recently. On a Win10Pro/Excel2013 box, I am having to deselect/reselect. the addin every time I open the worksheet. I have tried many things including running the smfFixLinks macro, which will activate the plugin for that session only. When you save the worksheet and reopen it, the links are broken again. I tried "unblock" on the general tab and it made no difference. I tried adding the SMF folder to the trusted zone and it appears to have made no difference.. Turned off virus protection, also no difference. Enabled all external content in the Trust Center= no difference. I did a "reset options" reinstall on the entire Office 2013 Suite and it made no difference. I am not sure what that really accomplished since the spreadsheet still had the SMF addin attached, so it is not clear what MS means when they supposedly reset to original defaults. I tried changing the folder holding the plugin and that also did not work, it just created false errors that the spreadsheet seemed to remember.
The only thing that worked was a did a fresh Win10Pro/Excel 2013 on a different box on it worked perfectly. Short of a clean install on my main box, I am out of ideas.
Any thoughts?
#yiv7121848035 #yiv7121848035 -- #yiv7121848035ygrp-
Fri Dec 6, 2019 1:05 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You should NEVER "change the array formula to point to where you put the
add in". That defeats the purpose of using an add-in. And causes problems
later, as you see. Because now you've MADE the formula a linked formula
instead of an add-in formula.
The whole point of using the smfFixLinks macro is to GET RID OF the
location attached to the function. The resolves it so that it MUST use the
function AS an add-in function.
Whenever you have a location error and unresolved links for the add-in, you
should immediately run the smfFixLinks macro and then save the worksheet.
Then, the next time you open it, it should automatically be using the
proper location for the add-in (unless you move the add-in).
On Thu, Dec 5, 2019 at 9:56 PM TN Bayless tnbayless@... wrote:
>
> Hi Randy, instead of using my spreadsheet, I downloaded the
> smfGetPortfolioView-Example template. I changed the array formula to point
> to where I put the add in. The data section performs exactly the same as my
> spreadsheet. It updates the first time you open it, then you save it and
> re-open it does not update. When you run the smfFixLinks macro, the sheet
> does update again.
>
> I added a separate tab just for the =RCHGetElementNumber("Version")
>
> It replied with:
>
> "Stock Market Functions add-in, Version 2.1.2018.01.24 (c:\Program Files
> (x86)\SMF_Add_in; Windows (64-bit) NT :.00; 15.0; ; ; 1)"
>
> and did NOT change when the sheet was saved and re-opened.
>
> Not sure what to make of it. . . .
>
>
>
add in". That defeats the purpose of using an add-in. And causes problems
later, as you see. Because now you've MADE the formula a linked formula
instead of an add-in formula.
The whole point of using the smfFixLinks macro is to GET RID OF the
location attached to the function. The resolves it so that it MUST use the
function AS an add-in function.
Whenever you have a location error and unresolved links for the add-in, you
should immediately run the smfFixLinks macro and then save the worksheet.
Then, the next time you open it, it should automatically be using the
proper location for the add-in (unless you move the add-in).
On Thu, Dec 5, 2019 at 9:56 PM TN Bayless tnbayless@..
>
> Hi Randy, instead of using my spreadsheet, I downloaded the
> smfGetPortfolioView
> to where I put the add in. The data section performs exactly the same as my
> spreadsheet. It updates the first time you open it, then you save it and
> re-open it does not update. When you run the smfFixLinks macro, the sheet
> does update again.
>
> I added a separate tab just for the =RCHGetElementNumbe
>
> It replied with:
>
> "Stock Market Functions add-in, Version 2.1.2018.01.
> (x86)\SMF_
>
> and did NOT change when the sheet was saved and re-opened.
>
> Not sure what to make of it. . . .
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar