7 Messages
Digest #3287
3c
Re: unable to copy and paste RCHGetYahooQuotes with relative referen by "Randy Harmelink" rharmelink
Messages
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/10 year model - GuruFocus - Non-Financials Only.xlsx
Uploaded by : hamishthedenizen <dan-carroll@yahoo.com>
Description : 10 Years of Financials for non-Financial companies only. Updated for minor changes in GF data
You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/10%20year%20model%20-%20GuruFocus%20-%20Non-Financials%20Only.xlsx
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
hamishthedenizen <dan-carroll@yahoo.com>
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/10 year model - GuruFocus - All Types.xlsx
Uploaded by : hamishthedenizen <dan-carroll@yahoo.com>
Description : 10 Year financial data from GF, updated
You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/10%20year%20model%20-%20GuruFocus%20-%20All%20Types.xlsx
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
hamishthedenizen <dan-carroll@yahoo.com>
Sun Jan 4, 2015 11:32 am (PST) . Posted by:
trendsekr
The addins have been working fine until moving to 8.1. Now after I open my spreadsheet, I have to open the addins file manually to get the data links to function.
Initial spreadsheet opening, addin looks like this:
='C:\Program Files (x86)\Microsoft Office\Office12\ADDINS\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetOptionQuotes( D26&" "& $B$24&" 2015"&" $"&I26&" Call", "l")
After I manually open RCH_stock_market_functions.xla it looks like this:
=RCH_Stock_Market_Functions.xla!smfGetOptionQuotes( D26&" "& $B$24&" 2015"&" $"&I26&" Call", "l")
and everything works as intended.
Suggestions appreciated.
(I love these functions. Don't know how I'd do without them.)
Initial spreadsheet opening, addin looks like this:
='C:\
After I manually open RCH_stock_market_
=RCH_Stock_Market_
and everything works as intended.
Suggestions appreciated.
(I love these functions. Don't know how I'd do without them.)
Sun Jan 4, 2015 11:58 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sounds like you just have location errors. EXCEL saves the location of the
add-in whenever it saves a workbook. When it opens that workbook later, it
looks for the add-in in that location. If it isn't there, it flags the
formula as having an unresolved link. That's why your formula has that path
in front of the function name.
Try running the smfFixLinks macro to fix all of those unresolved links. It
just does a "Find and Replace All" on your workbook, changing all of those
paths to nothing.
Once you have fixed the unresolved links and save the file, it should
re-open fine. Because when you save it, EXCEL will use the hard-coded
location of YOUR add-in under Windows 8.1. So next time the workbook is
opened, those links will not be unresolved.
For example, to manually fix your problem below, you could have done a
"Find and Replace All" on this string:
'C:\Program Files (x86)\Microsoft Office\Office12\ADDINS\SMF
Add-in\RCH_Stock_Market_Functions.xla'!
...changing it to be nothing.
On Sun, Jan 4, 2015 at 12:32 PM, trendsekr@... wrote:
> The addins have been working fine until moving to 8.1. Now after I open
> my spreadsheet, I have to open the addins file manually to get the data
> links to function.
>
> Initial spreadsheet opening, addin looks like this:
>
> ='C:\Program Files (x86)\Microsoft Office\Office12\ADDINS\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!smfGetOptionQuotes( D26&" "& $B$24&"
> 2015"&" $"&I26&" Call", "l")
>
> After I manually open RCH_stock_market_functions.xla it looks like this:
>
> =RCH_Stock_Market_Functions.xla!smfGetOptionQuotes( D26&" "& $B$24&"
> 2015"&" $"&I26&" Call", "l")
>
> and everything works as intended.
>
> Suggestions appreciated.
>
add-in whenever it saves a workbook. When it opens that workbook later, it
looks for the add-in in that location. If it isn't there, it flags the
formula as having an unresolved link. That's why your formula has that path
in front of the function name.
Try running the smfFixLinks macro to fix all of those unresolved links. It
just does a "Find and Replace All" on your workbook, changing all of those
paths to nothing.
Once you have fixed the unresolved links and save the file, it should
re-open fine. Because when you save it, EXCEL will use the hard-coded
location of YOUR add-in under Windows 8.1. So next time the workbook is
opened, those links will not be unresolved.
For example, to manually fix your problem below, you could have done a
"Find and Replace All" on this string:
'C:\
Add-in\RCH_
...changing it to be nothing.
On Sun, Jan 4, 2015 at 12:32 PM, trendsekr@..
> The addins have been working fine until moving to 8.1. Now after I open
> my spreadsheet, I have to open the addins file manually to get the data
> links to function.
>
> Initial spreadsheet opening, addin looks like this:
>
> ='C:\
> Add-in\RCH_
> 2015"&" $"&I26&" Call", "l"
>
> After I manually open RCH_stock_market_
>
> =RCH_Stock_Market_
> 2015"&" $"&I26&" Call", "l"
>
> and everything works as intended.
>
> Suggestions appreciated.
>
Sun Jan 4, 2015 5:44 pm (PST) . Posted by:
rydabbieri
So the issue happens on columns IW and greater. It used to be that IV was the last column that excel supported, but this spreadsheet was converted long ago to the 2007 xlsm format and should not have any limitations. I've also verified that the spreadsheet isn't opening in compatibility mode.
So far my google skills haven't turned anything up, but I think I'm on the right track as to what the issue is.
So far my google skills haven't turned anything up, but I think I'm on the right track as to what the issue is.
Sun Jan 4, 2015 6:24 pm (PST) . Posted by:
rydabbieri
=IW12 works fine, but =RCHGetYahooQuotes(IW12,"l1") becomes =RCHGetYahooQuotes(#REF!,"l1) . It appears to be something within the smf add-in when it's an unanchored reference to a column greater than IV. This is something that just started a few days ago because I have some cells with smf add-in formulas that were previously entered are returning values even though they referr to columns greater than IV. I tried removing and reinstalling smf add-in with no change.
I'm baffled. Maybe it's time to upgrade windows and try a newer version of office.
I'm baffled. Maybe it's time to upgrade windows and try a newer version of office.
Sun Jan 4, 2015 6:35 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It could be because the add-in was created with an earlier version of
EXCEL, before the additional columns existed.
But I would think that would be a worksheet process, not the add-in.
On Sun, Jan 4, 2015 at 7:24 PM, ryandabbieri@... wrote:
>
> =IW12 works fine, but =RCHGetYahooQuotes(IW12,"l1") becomes
> =RCHGetYahooQuotes(#REF!,"l1) . It appears to be something within the smf
> add-in when it's an unanchored reference to a column greater than IV. This
> is something that just started a few days ago because I have some cells
> with smf add-in formulas that were previously entered are returning values
> even though they referr to columns greater than IV. I tried removing and
> reinstalling smf add-in with no change.
>
> I'm baffled. Maybe it's time to upgrade windows and try a newer version
> of office.
>
EXCEL, before the additional columns existed.
But I would think that would be a worksheet process, not the add-in.
On Sun, Jan 4, 2015 at 7:24 PM, ryandabbieri@
>
> =IW12 works fine, but =RCHGetYahooQuotes(
> =RCHGetYahooQuotes(
> add-in when it's an unanchored reference to a column greater than IV. This
> is something that just started a few days ago because I have some cells
> with smf add-in formulas that were previously entered are returning values
> even though they referr to columns greater than IV. I tried removing and
> reinstalling smf add-in with no change.
>
> I'm baffled. Maybe it's time to upgrade windows and try a newer version
> of office.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar