8 Messages
Digest #3586
Messages
Thu Dec 17, 2015 11:14 am (PST) . Posted by:
jchealey66
Hi All,
I am using excel 2016 but cannot get the Fix Links and Force Recalculation Macros to work.
Just get message, macro cannot work with worksheet, you may need to enable macro settings etc.
Anybody else experienced the same / any problems?
I have enabled macros in the Trust Center Settings.
Thanks,
James
I am using excel 2016 but cannot get the Fix Links and Force Recalculation Macros to work.
Just get message, macro cannot work with worksheet, you may need to enable macro settings etc.
Anybody else experienced the same / any problems?
I have enabled macros in the Trust Center Settings.
Thanks,
James
Thu Dec 17, 2015 12:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I earlier versions, you didn't need to enable macros. That's a dangerous
setting to have.
Just the fact that you installed the add-in with the add-in manager should
have been permission enough.
Other than that, I'm clueless...
On Thu, Dec 17, 2015 at 12:14 PM, jameshealey@...wrote:
>
> I am using excel 2016 but cannot get the Fix Links and Force Recalculation
> Macros to work.
>
> Just get message, macro cannot work with worksheet, you may need to enable
> macro settings etc.
>
> Anybody else experienced the same / any problems?
>
> I have enabled macros in the Trust Center Settings.
>
>
setting to have.
Just the fact that you installed the add-in with the add-in manager should
have been permission enough.
Other than that, I'm clueless...
On Thu, Dec 17, 2015 at 12:14 PM, jameshealey@
>
> I am using excel 2016 but cannot get the Fix Links and Force Recalculation
> Macros to work.
>
> Just get message, macro cannot work with worksheet, you may need to enable
> macro settings etc.
>
> Anybody else experienced the same / any problems?
>
> I have enabled macros in the Trust Center Settings.
>
>
Thu Dec 17, 2015 1:10 pm (PST) . Posted by:
jchealey66
Hi Randy,
Thanks for your speedy reply.
Have fixed the problem now. Somehow after upgrading to windows 10 there is old older version of SMF hiding in a folder somewhere that I cannot access.
Once I re-installed latest version again in the add-in manager it has replaced older version and now everything works ok so far. Also now no need for fix links macro as I have same destination folder on both computers. Also gone back to safe setting in Trust Center.
Hopefully all good from here.
Happy Holidays.
Thanks again,
James
Thu Dec 17, 2015 9:10 pm (PST) . Posted by:
scottandrewjackson
Randy,
I'm not sure what I did wrong, but my spreadsheet isn't pulling data and the functions aren't working. Can you take a look at it and let me know if I'm doing something wrong?
-Scott
I'm not sure what I did wrong, but my spreadsheet isn't pulling data and the functions aren't working. Can you take a look at it and let me know if I'm doing something wrong?
-Scott
Attachment(s) from
1 of 1 File(s)
Thu Dec 17, 2015 9:50 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It worked fine here.
It would run a lot faster if you made those array-entered
RCHGetYahooQuotes() functions over a range.
Define "not working"? Are you seeing unresolved links? "Error" results?
What?
On Thu, Dec 17, 2015 at 10:10 PM, scottandrewjackson@...wrote:
>
> I'm not sure what I did wrong, but my spreadsheet isn't pulling data and
> the functions aren't working. Can you take a look at it and let me know if
> I'm doing something wrong?
>
>
>
It would run a lot faster if you made those array-entered
RCHGetYahooQuotes(
Define "not working"
What?
On Thu, Dec 17, 2015 at 10:10 PM, scottandrewjackson@
>
> I'm not sure what I did wrong, but my spreadsheet isn't pulling data and
> the functions aren't working. Can you take a look at it and let me know if
> I'm doing something wrong?
>
>
>
Thu Dec 17, 2015 10:18 pm (PST) . Posted by:
"Scott Jackson" scottandrewjackson
I'm not sure what I did but it's working now.
How would I enable the functions as an array? It's taking a while to update.
Also, is there a debt to equity function that I may input?
Thanks
> On Dec 17, 2015, at 9:50 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> It worked fine here.
>
> It would run a lot faster if you made those array-entered RCHGetYahooQuotes() functions over a range.
>
> Define "not working"? Are you seeing unresolved links? "Error" results? What?
>
> On Thu, Dec 17, 2015 at 10:10 PM, scottandrewjackson@...wrote:
>>
>> I'm not sure what I did wrong, but my spreadsheet isn't pulling data and the functions aren't working. Can you take a look at it and let me know if I'm doing something wrong?
>
>
How would I enable the functions as an array? It's taking a while to update.
Also, is there a debt to equity function that I may input?
Thanks
> On Dec 17, 2015, at 9:50 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> It worked fine here.
>
> It would run a lot faster if you made those array-entered RCHGetYahooQuotes(
>
> Define "not working"
>
> On Thu, Dec 17, 2015 at 10:10 PM, scottandrewjackson@
>>
>> I'm not sure what I did wrong, but my spreadsheet isn't pulling data and the functions aren't working. Can you take a look at it and let me know if I'm doing something wrong?
>
>
Thu Dec 17, 2015 10:28 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
On Thu, Dec 17, 2015 at 11:18 PM, Scott Jackson scottandrewjackson@...
wrote:
>
> I'm not sure what I did but it's working now.
>
> How would I enable the functions as an array? It's taking a while to
> update.
>
You need to array-enter the function over a range, giving it multiple
ticker symbols and/or Yahoo codes. It can be used for up to 200 ticker
symbols.
>
> Also, is there a debt to equity function that I may input?
>
>
Nothing for RCHGetYahooQuotes(). You'd need one of the other formulas.
wrote:
>
> I'm not sure what I did but it's working now.
>
> How would I enable the functions as an array? It's taking a while to
> update.
>
You need to array-enter the function over a range, giving it multiple
ticker symbols and/or Yahoo codes. It can be used for up to 200 ticker
symbols.
>
> Also, is there a debt to equity function that I may input?
>
>
Nothing for RCHGetYahooQuotes(
Thu Dec 17, 2015 10:28 pm (PST) . Posted by:
"Jim RACINOWSKI" jimrazz9
Scott,
It worked for me with excel 2007 and logged into FINVIZ without a premium
account.
Good Luck,
Jim
On Fri, Dec 18, 2015 at 12:10 AM, scottandrewjackson@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> [Attachment(s) <#151b37f401ea3b6f_TopText> from
> scottandrewjackson@yahoo.com [smf_addin] included below]
>
> Randy,
>
> I'm not sure what I did wrong, but my spreadsheet isn't pulling data and
> the functions aren't working. Can you take a look at it and let me know if
> I'm doing something wrong?
>
> -Scott
>
>
>
>
It worked for me with excel 2007 and logged into FINVIZ without a premium
account.
Good Luck,
Jim
On Fri, Dec 18, 2015 at 12:10 AM, scottandrewjackson@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> [Attachment(s) <#151b37f401ea3b6f_TopText> from
> scottandrewjackson@yahoo.com [smf_addin] included below]
>
> Randy,
>
> I'm not sure what I did wrong, but my spreadsheet isn't pulling data and
> the functions aren't working. Can you take a look at it and let me know if
> I'm doing something wrong?
>
> -Scott
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar