15 Messages
Digest #4314
Messages
Thu Mar 15, 2018 4:02 am (PDT) . Posted by:
stumpy_chris
Just starting happening. Excel will not pick up this function.
Is something being blocked. I keep get #NAME? in my cells.
Is something being blocked. I keep get #NAME? in my cells.
Thu Mar 15, 2018 4:19 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not quite understanding what you're saying, but this may be the issue
that first occurred in July of 2016 because MicroSoft issued some security
updates. It's not letting EXCEL load the add-in when EXCEL starts up. For a
workaround suggested by Microsoft, until they supposedly fix the issue, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
Otherwise, I'll need more details.
On Thu, Mar 15, 2018 at 4:01 AM, cschwartz@
...
wrote:
> Just starting happening. Excel will not pick up this function.
>
> Is something being blocked. I keep get #NAME? in my cells.
>
that first occurred in July of 2016 because MicroSoft issued some security
updates. It's not letting EXCEL load the add-in when EXCEL starts up. For a
workaround suggested by Microsoft, until they supposedly fix the issue, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
Otherwise, I'll need more details.
On Thu, Mar 15, 2018 at 4:01 AM, cschwartz@
...
wrote:
> Just starting happening. Excel will not pick up this function.
>
> Is something being blocked. I keep get #NAME? in my cells.
>
Thu Mar 15, 2018 4:45 pm (PDT) . Posted by:
stumpy_chris
Yes that seems to be the issue. And I think it happened about a new update went onto Windows 10 the other day.
Here a the steps I take:
1. I Click the Data tab, then Edit links
2. I click Change Source and locate the Stock Mkt Function file
3. When I click check status is says Source Unknown (ie it is not picking up the file)
I tried the steps in the link, but I can not see when you unblock a file.
Does this help with my issue.
Thanks
Here a the steps I take:
1. I Click the Data tab, then Edit links
2. I click Change Source and locate the Stock Mkt Function file
3. When I click check status is says Source Unknown (ie it is not picking up the file)
I tried the steps in the link, but I can not see when you unblock a file.
Does this help with my issue.
Thanks
Thu Mar 15, 2018 5:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I've never found the "Edit Links" option to work very well. In any case, it
would only address a links issue for a given workbook, not for EXCEL in
general.
You need to use the Windows File Explorer to unblock a file. A Google
search should find several examples. I've never done it myself.
On Thu, Mar 15, 2018 at 4:45 PM, cschwartz@
...
wrote:
>
> Yes that seems to be the issue. And I think it happened about a new update
> went onto Windows 10 the other day.
>
> Here a the steps I take:
> 1. I Click the Data tab, then Edit links
> 2. I click Change Source and locate the Stock Mkt Function file
> 3. When I click check status is says Source Unknown (ie it is not picking
> up the file)
>
> I tried the steps in the link, but I can not see when you unblock a file.
>
> Does this help with my issue.
>
>
would only address a links issue for a given workbook, not for EXCEL in
general.
You need to use the Windows File Explorer to unblock a file. A Google
search should find several examples. I've never done it myself.
On Thu, Mar 15, 2018 at 4:45 PM, cschwartz@
...
wrote:
>
> Yes that seems to be the issue. And I think it happened about a new update
> went onto Windows 10 the other day.
>
> Here a the steps I take:
> 1. I Click the Data tab, then Edit links
> 2. I click Change Source and locate the Stock Mkt Function file
> 3. When I click check status is says Source Unknown (ie it is not picking
> up the file)
>
> I tried the steps in the link, but I can not see when you unblock a file.
>
> Does this help with my issue.
>
>
Thu Mar 15, 2018 5:21 pm (PDT) . Posted by:
stumpy_chris
I have to use Edit Links in Excel in order to activate the SMF file - is there anther way to do this.
Thu Mar 15, 2018 5:21 pm (PDT) . Posted by:
stumpy_chris
I have to us the Edit Link option in order to activate the SMF file. Is there anther way to do this.
Thu Mar 15, 2018 5:32 pm (PDT) . Posted by:
"Frank kirk" nautilustech
I'm having a similar problem. Need to run the Fix Links macro every time I load an SMF workbook. Not a big deal; just a minor annoyance. However, this is only happening after a reinstallation of Windows 10.
Sent from Yahoo Mail on Android
On Thu, Mar 15, 2018 at 20:21, cschwartz@nf.sympatico.ca [smf_addin]<smf_addin@yahoogroups.com> wrote: #yiv7898636186 #yiv7898636186 -- #yiv7898636186 .yiv7898636186ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv7898636186 div.yiv7898636186ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv7898636186 div.yiv7898636186photo-title a, #yiv7898636186 div.yiv7898636186photo-title a:active, #yiv7898636186 div.yiv7898636186photo-title a:hover, #yiv7898636186 div.yiv7898636186photo-title a:visited {text-decoration:none;}#yiv7898636186 div.yiv7898636186attach-table div.yiv7898636186attach-row {clear:both;}#yiv7898636186 div.yiv7898636186attach-table div.yiv7898636186attach-row div {float:left;}#yiv7898636186 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv7898636186 div.yiv7898636186ygrp-file {width:30px;}#yiv7898636186 div.yiv7898636186attach-table div.yiv7898636186attach-row div div a {text-decoration:none;}#yiv7898636186 div.yiv7898636186attach-table div.yiv7898636186attach-row div div span {font-weight:normal;}#yiv7898636186 div.yiv7898636186ygrp-file-title {font-weight:bold;}#yiv7898636186 #yiv7898636186 #yiv7898636186 #yiv7898636186 --#yiv7898636186ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7898636186 #yiv7898636186ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7898636186 #yiv7898636186ygrp-mkp #yiv7898636186hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7898636186 #yiv7898636186ygrp-mkp #yiv7898636186ads {margin-bottom:10px;}#yiv7898636186 #yiv7898636186ygrp-mkp .yiv7898636186ad {padding:0 0;}#yiv7898636186 #yiv7898636186ygrp-mkp .yiv7898636186ad p {margin:0;}#yiv7898636186 #yiv7898636186ygrp-mkp .yiv7898636186ad a {color:#0000ff;text-decoration:none;}#yiv7898636186
I have to us the Edit Link option in order to activate the SMF file. Is there anther way to do this.
Sent from Yahoo Mail on Android
On Thu, Mar 15, 2018 at 20:21, cschwartz@nf.sympatico.ca [smf_addin]<smf_addin@yahoogroups.com> wrote: #yiv7898636186 #yiv7898636186 -- #yiv7898636186 .yiv7898636186ygrp-
I have to us the Edit Link option in order to activate the SMF file. Is there anther way to do this.
Thu Mar 15, 2018 5:56 pm (PDT) . Posted by:
"Frank kirk" nautilustech
How do you do this
Right click anywhere on the workbook. At bottom of the pop-up menu, scroll down to SMF. A sub menu appears with an option to Fix Links. Click on that.
Visit Your Group
- New Members 3
• Privacy • Unsubscribe • Terms of Use
#yiv5636886349 #yiv5636886349 -- #yiv5636886349 .yiv5636886349ygrp-
Thu Mar 15, 2018 6:05 pm (PDT) . Posted by:
stumpy_chris
I right clicked on a cell in the workbook. There is nothing there when I right click that relating to SMF.
Thu Mar 15, 2018 6:12 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Is the add-in activated in the add-in manager?
On Thu, Mar 15, 2018 at 6:05 PM, cschwartz@
...
wrote:
>
> I right clicked on a cell in the workbook. There is nothing there when I
> right click that relating to SMF.
>
>
>
On Thu, Mar 15, 2018 at 6:05 PM, cschwartz@
...
wrote:
>
> I right clicked on a cell in the workbook. There is nothing there when I
> right click that relating to SMF.
>
>
>
Thu Mar 15, 2018 6:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You shouldn't need to do it again for the same workbook, if it has been
saved after links were fixed.
EXCEL saves a hard-coded location of the add-in whenever you save a
workbook. If the add-in isn't in that hard-coded location the next time
that workbook is opened, you get "unresolved link" errors and need to run
the smfFixLinks macro. But if that workbook is saved, with the new location
of the add-in, it should find the add-in the next time the workbook is
opened.
But that will be on a workbook by workbook basis...
Where do you have the add-in located?
=RCHGetElementNumber("Version")
On Thu, Mar 15, 2018 at 5:28 PM, Frank kirk nautilustech@
...
wrote:
>
> I'm having a similar problem. Need to run the Fix Links macro every time I
> load an SMF workbook. Not a big deal; just a minor annoyance. However, this
> is only happening after a reinstallation of Windows 10.
>
>
saved after links were fixed.
EXCEL saves a hard-coded location of the add-in whenever you save a
workbook. If the add-in isn't in that hard-coded location the next time
that workbook is opened, you get "unresolved link" errors and need to run
the smfFixLinks macro. But if that workbook is saved, with the new location
of the add-in, it should find the add-in the next time the workbook is
opened.
But that will be on a workbook by workbook basis...
Where do you have the add-in located?
=RCHGetElementNumbe
On Thu, Mar 15, 2018 at 5:28 PM, Frank kirk nautilustech@
...
wrote:
>
> I'm having a similar problem. Need to run the Fix Links macro every time I
> load an SMF workbook. Not a big deal; just a minor annoyance. However, this
> is only happening after a reinstallation of Windows 10.
>
>
Thu Mar 15, 2018 6:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You should be doing it with the add-in manager.
On Thu, Mar 15, 2018 at 5:14 PM, cschwartz@
...
wrote:
>
> I have to use Edit Links in Excel in order to activate the SMF file - is
> there anther way to do this.
>
On Thu, Mar 15, 2018 at 5:14 PM, cschwartz@
...
wrote:
>
> I have to use Edit Links in Excel in order to activate the SMF file - is
> there anther way to do this.
>
Fri Mar 16, 2018 3:40 am (PDT) . Posted by:
stumpy_chris
- The Add-in is always activated - I need to go to "Edit Link" (under Data) in order to activate the SMF function - I don;t know why but I do
- The Version of SMF is from Jan.24/18
- The issue only started happening after a new update went on my computer from windows
- the SMFConvertData also doe snot work. It puts a blank in the cell.
- The Version of SMF is from Jan.24/18
- The issue only started happening after a new update went on my computer from windows
- the SMFConvertData also doe snot work. It puts a blank in the cell.
Thu Mar 15, 2018 10:58 pm (PDT) . Posted by:
greg_in_marin
Check out the CRYPTOFINANCE Google Sheets add-on. I have been using it for months, and it's really great!
The author's blog explains how to get historical data
https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14 https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14
Link to Add-on
https://chrome.google.com/webstore/detail/cryptofinance/bhjnahcnhemcnnenhgbmmdapapblnlcn?authuser=0 https://chrome.google.com/webstore/detail/cryptofinance/bhjnahcnhemcnnenhgbmmdapapblnlcn?authuser=0
The author's blog explains how to get historical data
https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14 https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14
Link to Add-on
https://chrome.google.com/webstore/detail/cryptofinance/bhjnahcnhemcnnenhgbmmdapapblnlcn?authuser=0 https://chrome.google.com/webstore/detail/cryptofinance/bhjnahcnhemcnnenhgbmmdapapblnlcn?authuser=0
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar