2 Messages

Digest #3661

rchgetyahoohistory problem by scottlangham

Re: rchgetyahoohistory problem by "Randy Harmelink" rharmelink

Messages

1a

My links have frozen on me.

The original formula of =rchgetyahoohistory(A1) comes back as:

='C:\Program Files\SMF add-in\RCH_Stock_Market_Functions.xla'!rchgetyahoohistory(A1)

When I try to overwrite the formula it just returns #name? in each cell.

I thought that my original sheet had just died, so I rebuld a version from scratch and it died after only a few days.

It seems like an excel problem - I can create good links in a new spreadsheet, so I don't think it is the add-in or yahoo? Any suggestions. I have already tried calculation options (not an automatic update issue).

Thanks
Scott

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

1b

Re: rchgetyahoohistory problem

Fri Mar 18, 2016 12:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

This can be a common situation when workbooks are shared. It occurs because
when you save your EXCEL workbook,MicroSoft decided to save the hard-coded
location of the add-in in the cell formula, so that EXCEL knows the
function comes from an external source. Then, when the file is opened,
EXCEL looks for that external source. If it finds it, it resolves the link
and removes the hard-coded location -- all is well. However, if it doesn't
find the external source, EXCEL marks it as an unresolved link, which makes
the cell non-functional until the link error is resolved.

Are you sharing this workbook between different machines, that have the
add-in located in different places?

My suspicion would be that EXCEL's add-in manager does NOT have the add-in
located at:

'C:\Program Files\SMF add-in\RCH_Stock_Market_Functions.xla'!

What do you get with:

=RCHGetElementNumber("Version")

In general, the hard-coded locations can be easily removed by running the
smfFixLinks macro. However, if the "Version" function indicates the add-in
*is* in that location, EXCEL may have some pointers mixed up. In that case,
you could try:

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 old location)
3. Restart EXCEL
4. Go to the add-in manager and put the add-in back into the list, using
its correct location
5. Exit EXCEL (to save the new settings)
6. Restart EXCEL

But you still may need to run the smfFixLinks on any workbooks that have a
bad hard-coded location of the add-in. But once the workbook is saved, the
issue should be resolved when you reopen the workbook on that same machine.

On Fri, Mar 18, 2016 at 9:15 AM, scottlangham@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> My links have frozen on me.
>
> The original formula of =rchgetyahoohistory(A1) comes back as:
>
> ='C:\Program Files\SMF
> add-in\RCH_Stock_Market_Functions.xla'!rchgetyahoohistory(A1)
>
> When I try to overwrite the formula it just returns #name? in each cell.
>
> I thought that my original sheet had just died, so I rebuld a version from
> scratch and it died after only a few days.
>
> It seems like an excel problem - I can create good links in a new
> spreadsheet, so I don't think it is the add-in or yahoo? Any suggestions.
> I have already tried calculation options (not an automatic update issue).
>
>