2 Messages

Digest #3565

Re: Not pulling in stock data by kjtemplin

Re: Not pulling in stock data by "Randy Harmelink" rharmelink

Messages

1a

I had to re-load my Excel program (don't ask) and now as usual I can't get the add-in to work. I like the functionality the add-in offers but every time I either update it or need to reload the Excel program, it gives me fits. I don't understand what I am doing wrong. The add-in was placed in the C: drive and it is properly loaded in the program. I click on update and it shows ok. But the values have not been updated.

Any help would be appreciated.

Thanks,
Ken Templin

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

1b

Re: Not pulling in stock data

Sat Nov 21, 2015 3:39 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try these steps:

1. Go to the add-in manager and uncheck the add-in (i.e. existing pointed
to location)
2. Exit EXCEL (to purge any connection to the add-in)
3. Restart EXCEL
4. Go to the add-in manager and put the add-in back into the list
5. Exit EXCEL (to save the new settings)
6. Restart EXCEL

After step 6, open a new workbook and make sure this returns an appropriate
version number:

=RCHGetElementNumber("Version")

...and that this returns 209.3108:

=RCHGetYahooQuotes("SPY","l1")

Then try your workbook again. Make sure there are no unresolved links. That
is, no hard drive path location prefixing your function invocations.

On Sat, Nov 21, 2015 at 1:11 PM, kjtemplin@icloud.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I had to re-load my Excel program (don't ask) and now as usual I can't get
> the add-in to work. I like the functionality the add-in offers but every
> time I either update it or need to reload the Excel program, it gives me
> fits. I don't understand what I am doing wrong. The add-in was placed in
> the C: drive and it is properly loaded in the program. I click on update
> and it shows ok. But the values have not been updated.
>
> Any help would be appreciated.
>
>