1 New Message
Digest #2781
Message
Sat Sep 21, 2013 8:19 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you saw a location in front of the function, adding the add-in to that
location doesn't help. You have to resolve the link errors before it can do
the recalculation you need.
Check the "Location errors" item in the LINKS area of the Yahoo group. Or
try just running the smfFixLinks macro that is part of the add-in.
On Sat, Sep 21, 2013 at 7:20 PM, Deborah <dcharlotte99@yahoo.com> wrote:
> First, my thanks to John Babcock for the new ADVFN 10-yr financial
> spreadsheet that works with the changes to the ADVFN website. It will be a
> lifesaver once I get it to update.
>
> That's my problem, the spreadsheet won't recalculate when I enter a new
> ticker.
>
> F9 changes the company and exchange info cells as well as the URL cells
> John includes. But all the data is $0.00. There are no error codes.
>
> I noticed the spreadsheet uses C:/SMF for the Add-in location, I created
> that. I've had the add-in installed at C:/Program Files/SMF Add-in for
> several years. I made sure the Add-in is active in the Excel Options.
>
> Any clues why the data doesn't update?
>
location doesn't help. You have to resolve the link errors before it can do
the recalculation you need.
Check the "Location errors" item in the LINKS area of the Yahoo group. Or
try just running the smfFixLinks macro that is part of the add-in.
On Sat, Sep 21, 2013 at 7:20 PM, Deborah <dcharlotte99@
> First, my thanks to John Babcock for the new ADVFN 10-yr financial
> spreadsheet that works with the changes to the ADVFN website. It will be a
> lifesaver once I get it to update.
>
> That's my problem, the spreadsheet won't recalculate when I enter a new
> ticker.
>
> F9 changes the company and exchange info cells as well as the URL cells
> John includes. But all the data is $0.00. There are no error codes.
>
> I noticed the spreadsheet uses C:/SMF for the Add-in location, I created
> that. I've had the add-in installed at C:/Program Files/SMF Add-in for
> several years. I made sure the Add-in is active in the Excel Options.
>
> Any clues why the data doesn't update?
>
Tidak ada komentar:
Posting Komentar