[smf_addin] Digest Number 3926[1 Attachment]

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3926

1.1

Re: Microsoft Excel security message by lefthand43

1.2

Re: Microsoft Excel security message by "Randy Harmelink" rharmelink

2a

Can't get this sheet to work by jgrimm2391

2b

Re: Can't get this sheet to work [1 Attachment] by "Randy Harmelink" rharmelink

Messages

1.1

Re: Microsoft Excel security message

Wed Feb 22, 2017 2:20 am (PST) . Posted by:

lefthand43

I think I'm having the same problem; I'm getting 404 errors when I run f9 to calculate my spreadsheet. SMF Addin is showing as loaded (under Excel Options). This worked before.

So I tried to follow the two instructions above. My excel file was not blocked, so instruction 1, no worky. Instruction #2, I got stuck on "You can save the web html file... what html file? My file is a spreadsheet. There must be a web site that SMF addin calls... how do I find out what it is? ...So close... Please help...


Thxs in advance
Ken

Reply to sender . Reply to group . Reply via Web Post . All Messages (41) . Top ^

1.2

Re: Microsoft Excel security message

Wed Feb 22, 2017 3:12 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I'm not sure what you're referring to when you say "instructions above".

404 errors?

Examples of functions being used?

F9 isn't typically used to recalculate add-in functions. You would need to
use smfForceRecalculation (see FAQs and Tips web page).

On Tue, Feb 21, 2017 at 8:48 PM, lefthand43@
​...wrote:

>
>
> I think I'm having the same problem; I'm getting 404 errors when I run f9
> to calculate my spreadsheet. SMF Addin is showing as loaded (under Excel
> Options). This worked before.
>
> So I tried to follow the two instructions above. My excel file was not
> blocked, so instruction 1, no worky. Instruction #2, I got stuck on "You
> can save the web html file... what html file? My file is a spreadsheet.
> There must be a web site that SMF addin calls... how do I find out what it
> is? ...So close... Please help...
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (41) . Top ^

2a

Can't get this sheet to work

Wed Feb 22, 2017 2:23 am (PST) . Posted by:

jgrimm2391

I've tried several times to post this sheet for help getting it to work. Please let me know if you can help.


Using Excel 2013, I was last successful on 2/3/17 getting this to produce.


Thanks
Joel

Attachment(s) from

1 of 1 File(s)

Stock Picks trial.xlsx

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: Can't get this sheet to work [1 Attachment]

Wed Feb 22, 2017 3:36 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The problem is that the add-in has a built-in limit of 1000 web pages per
"session". Anything attempts to retrieve a web page beyond that 1000 web
page limit will return "Error".

On Tue, Feb 21, 2017 at 6:04 PM, jgrimm2391
​...wrote:

>
> I've tried several times to post this sheet for help getting it to work.
> Please let me know if you can help.
>
> Using Excel 2013, I was last successful on 2/3/17 getting this to produce.
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 12

• Privacy • Unsubscribe • Terms of Use