12 New Messages
Digest #2372
Messages
Thu Oct 11, 2012 5:51 am (PDT) . Posted by:
"mff2805" mff2805
hi,
i'm still stuck on this. i have the addin in the std folder. i have created a ss twith about 20 tabs, pulling info from various interent sources (based on the various templates), and a sumamry tab where i look at things that i really want to see, my way. works well.
but when i open that file, i get the msg that links cannot be updated. i then edit links and the source is the rch...xla file, and the status is 'source is open'. when i close that window, i can then proceed changing the ticker, etc. i've lived with this step for quite a while, but now have time to figure out how to stop this from happening.
i copied the find/replacemacro from the msg in the links area, and ran it on every sheet. before that i did a manual find on every sheet, looking for the "rch_stock" string, but it is nowhere.
so, i'm not sure why excel gives me that msg when i open my file. in the date>edit link, update is set to automatic, the startup prompt is "don't display the alert and update links", and in the file options>advanced>general, i have the "ask to update automatic links" unchecked. (although i had it checked in the past with no change).
any thoughts or comments?
thanks much,
mike
i'm still stuck on this. i have the addin in the std folder. i have created a ss twith about 20 tabs, pulling info from various interent sources (based on the various templates), and a sumamry tab where i look at things that i really want to see, my way. works well.
but when i open that file, i get the msg that links cannot be updated. i then edit links and the source is the rch...xla file, and the status is 'source is open'. when i close that window, i can then proceed changing the ticker, etc. i've lived with this step for quite a while, but now have time to figure out how to stop this from happening.
i copied the find/replacemacro from the msg in the links area, and ran it on every sheet. before that i did a manual find on every sheet, looking for the "rch_stock" string, but it is nowhere.
so, i'm not sure why excel gives me that msg when i open my file. in the date>edit link, update is set to automatic, the startup prompt is "don't display the alert and update links", and in the file options>advanced>
any thoughts or comments?
thanks much,
mike
Thu Oct 11, 2012 6:51 am (PDT) . Posted by:
"dguillett1" donaldb36
defined name?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
From: mff2805
Sent: Thursday, October 11, 2012 7:51 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] edit links msg when opening a file that uses the addin
hi,
i'm still stuck on this. i have the addin in the std folder. i have created a ss twith about 20 tabs, pulling info from various interent sources (based on the various templates), and a sumamry tab where i look at things that i really want to see, my way. works well.
but when i open that file, i get the msg that links cannot be updated. i then edit links and the source is the rch...xla file, and the status is 'source is open'. when i close that window, i can then proceed changing the ticker, etc. i've lived with this step for quite a while, but now have time to figure out how to stop this from happening.
i copied the find/replacemacro from the msg in the links area, and ran it on every sheet. before that i did a manual find on every sheet, looking for the "rch_stock" string, but it is nowhere.
so, i'm not sure why excel gives me that msg when i open my file. in the date>edit link, update is set to automatic, the startup prompt is "don't display the alert and update links", and in the file options>advanced>general, i have the "ask to update automatic links" unchecked. (although i had it checked in the past with no change).
any thoughts or comments?
thanks much,
mike
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
From: mff2805
Sent: Thursday, October 11, 2012 7:51 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] edit links msg when opening a file that uses the addin
hi,
i'm still stuck on this. i have the addin in the std folder. i have created a ss twith about 20 tabs, pulling info from various interent sources (based on the various templates), and a sumamry tab where i look at things that i really want to see, my way. works well.
but when i open that file, i get the msg that links cannot be updated. i then edit links and the source is the rch...xla file, and the status is 'source is open'. when i close that window, i can then proceed changing the ticker, etc. i've lived with this step for quite a while, but now have time to figure out how to stop this from happening.
i copied the find/replacemacro from the msg in the links area, and ran it on every sheet. before that i did a manual find on every sheet, looking for the "rch_stock" string, but it is nowhere.
so, i'm not sure why excel gives me that msg when i open my file. in the date>edit link, update is set to automatic, the startup prompt is "don't display the alert and update links", and in the file options>advanced>
any thoughts or comments?
thanks much,
mike
Thu Oct 11, 2012 8:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It sounds to me like you don't have the add-in activated properly.
The only time links should need to be edited for the add-in is if you are
opening up a file that was saved with the add-in in a different location.
On Thu, Oct 11, 2012 at 5:51 AM, mff2805 <mff3429@comcast.net > wrote:
> hi,
> i'm still stuck on this. i have the addin in the std folder. i have
> created a ss twith about 20 tabs, pulling info from various interent
> sources (based on the various templates), and a sumamry tab where i look at
> things that i really want to see, my way. works well.
> but when i open that file, i get the msg that links cannot be updated. i
> then edit links and the source is the rch...xla file, and the status is
> 'source is open'. when i close that window, i can then proceed changing
> the ticker, etc. i've lived with this step for quite a while, but now have
> time to figure out how to stop this from happening.
> i copied the find/replacemacro from the msg in the links area, and ran it
> on every sheet. before that i did a manual find on every sheet, looking
> for the "rch_stock" string, but it is nowhere.
>
> so, i'm not sure why excel gives me that msg when i open my file. in the
> date>edit link, update is set to automatic, the startup prompt is "don't
> display the alert and update links", and in the file
> options>advanced>general, i have the "ask to update automatic links"
> unchecked. (although i had it checked in the past with no change).
>
> any thoughts or comments?
> thanks much,
> mike
>
The only time links should need to be edited for the add-in is if you are
opening up a file that was saved with the add-in in a different location.
On Thu, Oct 11, 2012 at 5:51 AM, mff2805 <mff3429@comcast.
> hi,
> i'm still stuck on this. i have the addin in the std folder. i have
> created a ss twith about 20 tabs, pulling info from various interent
> sources (based on the various templates), and a sumamry tab where i look at
> things that i really want to see, my way. works well.
> but when i open that file, i get the msg that links cannot be updated. i
> then edit links and the source is the rch...xla file, and the status is
> 'source is open'. when i close that window, i can then proceed changing
> the ticker, etc. i've lived with this step for quite a while, but now have
> time to figure out how to stop this from happening.
> i copied the find/replacemacro from the msg in the links area, and ran it
> on every sheet. before that i did a manual find on every sheet, looking
> for the "rch_stock" string, but it is nowhere.
>
> so, i'm not sure why excel gives me that msg when i open my file. in the
> date>edit link, update is set to automatic, the startup prompt is "don't
> display the alert and update links", and in the file
> options>advanced>
> unchecked. (although i had it checked in the past with no change).
>
> any thoughts or comments?
> thanks much,
> mike
>
Thu Oct 11, 2012 8:35 am (PDT) . Posted by:
"mff2805" mff2805
mot sure what you mean by your question. in the whole workbook, there are just a few defined names. i can step thru each of them, they are just references to single cells that exist on certain sheets in the workbook. no defined nme that reference outside workbooks.
can you clarify your question?
--- In smf_addin@yahoogroups.com , "dguillett1" <dguillett1@...> wrote:
>
> defined name?
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@...
>
> From: mff2805
> Sent: Thursday, October 11, 2012 7:51 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] edit links msg when opening a file that uses the addin
>
>
> hi,
> i'm still stuck on this. i have the addin in the std folder. i have created a ss twith about 20 tabs, pulling info from various interent sources (based on the various templates), and a sumamry tab where i look at things that i really want to see, my way. works well.
> but when i open that file, i get the msg that links cannot be updated. i then edit links and the source is the rch...xla file, and the status is 'source is open'. when i close that window, i can then proceed changing the ticker, etc. i've lived with this step for quite a while, but now have time to figure out how to stop this from happening.
> i copied the find/replacemacro from the msg in the links area, and ran it on every sheet. before that i did a manual find on every sheet, looking for the "rch_stock" string, but it is nowhere.
>
> so, i'm not sure why excel gives me that msg when i open my file. in the date>edit link, update is set to automatic, the startup prompt is "don't display the alert and update links", and in the file options>advanced>general, i have the "ask to update automatic links" unchecked. (although i had it checked in the past with no change).
>
> any thoughts or comments?
> thanks much,
> mike
>
can you clarify your question?
--- In smf_addin@yahoogrou
>
> defined name?
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@.
>
> From: mff2805
> Sent: Thursday, October 11, 2012 7:51 AM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] edit links msg when opening a file that uses the addin
>
>
> hi,
> i'm still stuck on this. i have the addin in the std folder. i have created a ss twith about 20 tabs, pulling info from various interent sources (based on the various templates), and a sumamry tab where i look at things that i really want to see, my way. works well.
> but when i open that file, i get the msg that links cannot be updated. i then edit links and the source is the rch...xla file, and the status is 'source is open'. when i close that window, i can then proceed changing the ticker, etc. i've lived with this step for quite a while, but now have time to figure out how to stop this from happening.
> i copied the find/replacemacro from the msg in the links area, and ran it on every sheet. before that i did a manual find on every sheet, looking for the "rch_stock" string, but it is nowhere.
>
> so, i'm not sure why excel gives me that msg when i open my file. in the date>edit link, update is set to automatic, the startup prompt is "don't display the alert and update links", and in the file options>advanced>
>
> any thoughts or comments?
> thanks much,
> mike
>
Thu Oct 11, 2012 9:31 am (PDT) . Posted by:
"dguillett1" donaldb36
In the file you sent me there were defined name that referred to 4 cells on sheet1. One was not the same size.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
From: mff2805
Sent: Thursday, October 11, 2012 10:35 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: edit links msg when opening a file that uses the addin
mot sure what you mean by your question. in the whole workbook, there are just a few defined names. i can step thru each of them, they are just references to single cells that exist on certain sheets in the workbook. no defined nme that reference outside workbooks.
can you clarify your question?
--- In mailto:smf_addin%40yahoogroups.com, "dguillett1" <dguillett1@...> wrote:
>
> defined name?
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@...
>
> From: mff2805
> Sent: Thursday, October 11, 2012 7:51 AM
> To: mailto:smf_addin%40yahoogroups.com
> Subject: [smf_addin] edit links msg when opening a file that uses the addin
>
>
> hi,
> i'm still stuck on this. i have the addin in the std folder. i have created a ss twith about 20 tabs, pulling info from various interent sources (based on the various templates), and a sumamry tab where i look at things that i really want to see, my way. works well.
> but when i open that file, i get the msg that links cannot be updated. i then edit links and the source is the rch...xla file, and the status is 'source is open'. when i close that window, i can then proceed changing the ticker, etc. i've lived with this step for quite a while, but now have time to figure out how to stop this from happening.
> i copied the find/replacemacro from the msg in the links area, and ran it on every sheet. before that i did a manual find on every sheet, looking for the "rch_stock" string, but it is nowhere.
>
> so, i'm not sure why excel gives me that msg when i open my file. in the date>edit link, update is set to automatic, the startup prompt is "don't display the alert and update links", and in the file options>advanced>general, i have the "ask to update automatic links" unchecked. (although i had it checked in the past with no change).
>
> any thoughts or comments?
> thanks much,
> mike
>
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
From: mff2805
Sent: Thursday, October 11, 2012 10:35 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: edit links msg when opening a file that uses the addin
mot sure what you mean by your question. in the whole workbook, there are just a few defined names. i can step thru each of them, they are just references to single cells that exist on certain sheets in the workbook. no defined nme that reference outside workbooks.
can you clarify your question?
--- In mailto:smf_addin%
>
> defined name?
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@.
>
> From: mff2805
> Sent: Thursday, October 11, 2012 7:51 AM
> To: mailto:smf_addin%
> Subject: [smf_addin] edit links msg when opening a file that uses the addin
>
>
> hi,
> i'm still stuck on this. i have the addin in the std folder. i have created a ss twith about 20 tabs, pulling info from various interent sources (based on the various templates), and a sumamry tab where i look at things that i really want to see, my way. works well.
> but when i open that file, i get the msg that links cannot be updated. i then edit links and the source is the rch...xla file, and the status is 'source is open'. when i close that window, i can then proceed changing the ticker, etc. i've lived with this step for quite a while, but now have time to figure out how to stop this from happening.
> i copied the find/replacemacro from the msg in the links area, and ran it on every sheet. before that i did a manual find on every sheet, looking for the "rch_stock" string, but it is nowhere.
>
> so, i'm not sure why excel gives me that msg when i open my file. in the date>edit link, update is set to automatic, the startup prompt is "don't display the alert and update links", and in the file options>advanced>
>
> any thoughts or comments?
> thanks much,
> mike
>
Attachments with this message:
1 of 1 File(s)
Thu Oct 11, 2012 4:26 pm (PDT) . Posted by:
"mff2805" mff2805
sorry, don. i didn't send a file. must have been a different question
--- In smf_addin@yahoogroups.com , "dguillett1" <dguillett1@...> wrote:
>
> In the file you sent me there were defined name that referred to 4 cells on sheet1. One was not the same size.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@...
>
> From: mff2805
> Sent: Thursday, October 11, 2012 10:35 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: edit links msg when opening a file that uses the addin
>
>
> mot sure what you mean by your question. in the whole workbook, there are just a few defined names. i can step thru each of them, they are just references to single cells that exist on certain sheets in the workbook. no defined nme that reference outside workbooks.
> can you clarify your question?
>
> --- In mailto:smf_addin%40yahoogroups.com, "dguillett1" <dguillett1@> wrote:
> >
> > defined name?
> >
> > Don Guillett
> > Microsoft Excel Developer
> > SalesAid Software
> > dguillett1@
> >
> > From: mff2805
> > Sent: Thursday, October 11, 2012 7:51 AM
> > To: mailto:smf_addin%40yahoogroups.com
> > Subject: [smf_addin] edit links msg when opening a file that uses the addin
> >
> >
> > hi,
> > i'm still stuck on this. i have the addin in the std folder. i have created a ss twith about 20 tabs, pulling info from various interent sources (based on the various templates), and a sumamry tab where i look at things that i really want to see, my way. works well.
> > but when i open that file, i get the msg that links cannot be updated. i then edit links and the source is the rch...xla file, and the status is 'source is open'. when i close that window, i can then proceed changing the ticker, etc. i've lived with this step for quite a while, but now have time to figure out how to stop this from happening.
> > i copied the find/replacemacro from the msg in the links area, and ran it on every sheet. before that i did a manual find on every sheet, looking for the "rch_stock" string, but it is nowhere.
> >
> > so, i'm not sure why excel gives me that msg when i open my file. in the date>edit link, update is set to automatic, the startup prompt is "don't display the alert and update links", and in the file options>advanced>general, i have the "ask to update automatic links" unchecked. (although i had it checked in the past with no change).
> >
> > any thoughts or comments?
> > thanks much,
> > mike
> >
>
--- In smf_addin@yahoogrou
>
> In the file you sent me there were defined name that referred to 4 cells on sheet1. One was not the same size.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@.
>
> From: mff2805
> Sent: Thursday, October 11, 2012 10:35 AM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] Re: edit links msg when opening a file that uses the addin
>
>
> mot sure what you mean by your question. in the whole workbook, there are just a few defined names. i can step thru each of them, they are just references to single cells that exist on certain sheets in the workbook. no defined nme that reference outside workbooks.
> can you clarify your question?
>
> --- In mailto:smf_addin%
> >
> > defined name?
> >
> > Don Guillett
> > Microsoft Excel Developer
> > SalesAid Software
> > dguillett1@
> >
> > From: mff2805
> > Sent: Thursday, October 11, 2012 7:51 AM
> > To: mailto:smf_addin%
> > Subject: [smf_addin] edit links msg when opening a file that uses the addin
> >
> >
> > hi,
> > i'm still stuck on this. i have the addin in the std folder. i have created a ss twith about 20 tabs, pulling info from various interent sources (based on the various templates), and a sumamry tab where i look at things that i really want to see, my way. works well.
> > but when i open that file, i get the msg that links cannot be updated. i then edit links and the source is the rch...xla file, and the status is 'source is open'. when i close that window, i can then proceed changing the ticker, etc. i've lived with this step for quite a while, but now have time to figure out how to stop this from happening.
> > i copied the find/replacemacro from the msg in the links area, and ran it on every sheet. before that i did a manual find on every sheet, looking for the "rch_stock" string, but it is nowhere.
> >
> > so, i'm not sure why excel gives me that msg when i open my file. in the date>edit link, update is set to automatic, the startup prompt is "don't display the alert and update links", and in the file options>advanced>
> >
> > any thoughts or comments?
> > thanks much,
> > mike
> >
>
Thu Oct 11, 2012 4:33 pm (PDT) . Posted by:
"mff2805" mff2805
thanks. what do you mean by properly activated?
i scanned all the tab looking for "C:". in case there were remnants, but nothing was found. i even rename the folder where i store donwloaded templates, think some remnants might still exist in my file. same behavior.
when excel opens my file, and i'm prompted to edit links,, the edit links window only has the "rch" file, with a status is 'unknown'. when i click 'check status', the status changes to 'source is open' and i'm good to go.
maybe i
ll try uninsatlling the addin and reinstalling it.
but if you have more comments, i'd appreciate it.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It sounds to me like you don't have the add-in activated properly.
>
> The only time links should need to be edited for the add-in is if you are
> opening up a file that was saved with the add-in in a different location.
>
>
>
> On Thu, Oct 11, 2012 at 5:51 AM, mff2805 <mff3429@...> wrote:
>
> > hi,
> > i'm still stuck on this. i have the addin in the std folder. i have
> > created a ss twith about 20 tabs, pulling info from various interent
> > sources (based on the various templates), and a sumamry tab where i look at
> > things that i really want to see, my way. works well.
> > but when i open that file, i get the msg that links cannot be updated. i
> > then edit links and the source is the rch...xla file, and the status is
> > 'source is open'. when i close that window, i can then proceed changing
> > the ticker, etc. i've lived with this step for quite a while, but now have
> > time to figure out how to stop this from happening.
> > i copied the find/replacemacro from the msg in the links area, and ran it
> > on every sheet. before that i did a manual find on every sheet, looking
> > for the "rch_stock" string, but it is nowhere.
> >
> > so, i'm not sure why excel gives me that msg when i open my file. in the
> > date>edit link, update is set to automatic, the startup prompt is "don't
> > display the alert and update links", and in the file
> > options>advanced>general, i have the "ask to update automatic links"
> > unchecked. (although i had it checked in the past with no change).
> >
> > any thoughts or comments?
> > thanks much,
> > mike
> >
>
i scanned all the tab looking for "C:". in case there were remnants, but nothing was found. i even rename the folder where i store donwloaded templates, think some remnants might still exist in my file. same behavior.
when excel opens my file, and i'm prompted to edit links,, the edit links window only has the "rch" file, with a status is 'unknown'. when i click 'check status', the status changes to 'source is open' and i'm good to go.
maybe i
ll try uninsatlling the addin and reinstalling it.
but if you have more comments, i'd appreciate it.
--- In smf_addin@yahoogrou
>
> It sounds to me like you don't have the add-in activated properly.
>
> The only time links should need to be edited for the add-in is if you are
> opening up a file that was saved with the add-in in a different location.
>
>
>
> On Thu, Oct 11, 2012 at 5:51 AM, mff2805 <mff3429@...
>
> > hi,
> > i'm still stuck on this. i have the addin in the std folder. i have
> > created a ss twith about 20 tabs, pulling info from various interent
> > sources (based on the various templates), and a sumamry tab where i look at
> > things that i really want to see, my way. works well.
> > but when i open that file, i get the msg that links cannot be updated. i
> > then edit links and the source is the rch...xla file, and the status is
> > 'source is open'. when i close that window, i can then proceed changing
> > the ticker, etc. i've lived with this step for quite a while, but now have
> > time to figure out how to stop this from happening.
> > i copied the find/replacemacro from the msg in the links area, and ran it
> > on every sheet. before that i did a manual find on every sheet, looking
> > for the "rch_stock" string, but it is nowhere.
> >
> > so, i'm not sure why excel gives me that msg when i open my file. in the
> > date>edit link, update is set to automatic, the startup prompt is "don't
> > display the alert and update links", and in the file
> > options>advanced>
> > unchecked. (although i had it checked in the past with no change).
> >
> > any thoughts or comments?
> > thanks much,
> > mike
> >
>
Thu Oct 11, 2012 6:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
In the past, I've not found the EXCEL "Edit Links" dialog to be a reliable
way to "fix" link errors related to the add-in.
Check out the "Link errors" item in the LINKS section of the Yahoo group.
If you close EXCEL, restart it, what do you get with this formula:
=RCHGetElementNumber("Version")
Location of the EXCEL worksheets will make no difference on add-in location
errors. It's telling you it can't find the add-in where the saved workbook
is claiming it should be. If you save the workbook after fixing location
errors, you should NOT get a location error upon opening the workbook again
unless you've moved the add-in.
On Thu, Oct 11, 2012 at 4:33 PM, mff2805 <mff3429@comcast.net > wrote:
> thanks. what do you mean by properly activated?
> i scanned all the tab looking for "C:". in case there were remnants, but
> nothing was found. i even rename the folder where i store donwloaded
> templates, think some remnants might still exist in my file. same behavior.
> when excel opens my file, and i'm prompted to edit links,, the edit links
> window only has the "rch" file, with a status is 'unknown'. when i click
> 'check status', the status changes to 'source is open' and i'm good to go.
> maybe i
> ll try uninsatlling the addin and reinstalling it.
> but if you have more comments, i'd appreciate it.
>
way to "fix" link errors related to the add-in.
Check out the "Link errors" item in the LINKS section of the Yahoo group.
If you close EXCEL, restart it, what do you get with this formula:
=RCHGetElementNumbe
Location of the EXCEL worksheets will make no difference on add-in location
errors. It's telling you it can't find the add-in where the saved workbook
is claiming it should be. If you save the workbook after fixing location
errors, you should NOT get a location error upon opening the workbook again
unless you've moved the add-in.
On Thu, Oct 11, 2012 at 4:33 PM, mff2805 <mff3429@comcast.
> thanks. what do you mean by properly activated?
> i scanned all the tab looking for "C:". in case there were remnants, but
> nothing was found. i even rename the folder where i store donwloaded
> templates, think some remnants might still exist in my file. same behavior.
> when excel opens my file, and i'm prompted to edit links,, the edit links
> window only has the "rch" file, with a status is 'unknown'. when i click
> 'check status', the status changes to 'source is open' and i'm good to go.
> maybe i
> ll try uninsatlling the addin and reinstalling it.
> but if you have more comments, i'd appreciate it.
>
Thu Oct 11, 2012 7:59 pm (PDT) . Posted by:
"mff2805" mff2805
i get
Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program Files\SMF Add-In; 1)
i'm still stumped
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> In the past, I've not found the EXCEL "Edit Links" dialog to be a reliable
> way to "fix" link errors related to the add-in.
>
> Check out the "Link errors" item in the LINKS section of the Yahoo group.
>
> If you close EXCEL, restart it, what do you get with this formula:
>
> =RCHGetElementNumber("Version")
>
> Location of the EXCEL worksheets will make no difference on add-in location
> errors. It's telling you it can't find the add-in where the saved workbook
> is claiming it should be. If you save the workbook after fixing location
> errors, you should NOT get a location error upon opening the workbook again
> unless you've moved the add-in.
>
> On Thu, Oct 11, 2012 at 4:33 PM, mff2805 <mff3429@...> wrote:
>
> > thanks. what do you mean by properly activated?
> > i scanned all the tab looking for "C:". in case there were remnants, but
> > nothing was found. i even rename the folder where i store donwloaded
> > templates, think some remnants might still exist in my file. same behavior.
> > when excel opens my file, and i'm prompted to edit links,, the edit links
> > window only has the "rch" file, with a status is 'unknown'. when i click
> > 'check status', the status changes to 'source is open' and i'm good to go.
> > maybe i
> > ll try uninsatlling the addin and reinstalling it.
> > but if you have more comments, i'd appreciate it.
> >
>
Stock Market Functions add-in, Version 2.1.2012.02.
i'm still stumped
--- In smf_addin@yahoogrou
>
> In the past, I've not found the EXCEL "Edit Links" dialog to be a reliable
> way to "fix" link errors related to the add-in.
>
> Check out the "Link errors" item in the LINKS section of the Yahoo group.
>
> If you close EXCEL, restart it, what do you get with this formula:
>
> =RCHGetElementNumbe
>
> Location of the EXCEL worksheets will make no difference on add-in location
> errors. It's telling you it can't find the add-in where the saved workbook
> is claiming it should be. If you save the workbook after fixing location
> errors, you should NOT get a location error upon opening the workbook again
> unless you've moved the add-in.
>
> On Thu, Oct 11, 2012 at 4:33 PM, mff2805 <mff3429@...
>
> > thanks. what do you mean by properly activated?
> > i scanned all the tab looking for "C:". in case there were remnants, but
> > nothing was found. i even rename the folder where i store donwloaded
> > templates, think some remnants might still exist in my file. same behavior.
> > when excel opens my file, and i'm prompted to edit links,, the edit links
> > window only has the "rch" file, with a status is 'unknown'. when i click
> > 'check status', the status changes to 'source is open' and i'm good to go.
> > maybe i
> > ll try uninsatlling the addin and reinstalling it.
> > but if you have more comments, i'd appreciate it.
> >
>
Thu Oct 11, 2012 8:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't think your links problem is with the add-in.
If I open a functioning worksheet that uses the add-in, and flags no link
errors, I can also open "Edit Links" and see the add-in there with an
"Unknown" status.
Does this happen with any other workbook that uses the add-in?
On Thu, Oct 11, 2012 at 7:59 PM, mff2805 <mff3429@comcast.net > wrote:
> i get
> Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program
> Files\SMF Add-In; 1)
>
> i'm still stumped
>
If I open a functioning worksheet that uses the add-in, and flags no link
errors, I can also open "Edit Links" and see the add-in there with an
"Unknown" status.
Does this happen with any other workbook that uses the add-in?
On Thu, Oct 11, 2012 at 7:59 PM, mff2805 <mff3429@comcast.
> i get
> Stock Market Functions add-in, Version 2.1.2012.02.
> Files\SMF Add-In; 1)
>
> i'm still stumped
>
Thu Oct 11, 2012 11:53 am (PDT) . Posted by:
"Randy H" rharmelink
No idea of where it might be found...
--- In smf_addin@yahoogrou
>
> Can someone show me where/how I may get, using smf, the price/ffo
> ratio where ffo is funds from operations? I understand this metric
> is useful for reits and business development companies. Thanks.
Thu Oct 11, 2012 11:02 pm (PDT) . Posted by:
"mdkumar kumar" mdkumarz
Dear All,
This is the website link for knowing the good reasons behind our
rituals.
http://hindu-hiddenfacts.blogspot.in/2011/11/what-is-meant-by-brahma-muhurtham.html
--
Yours sincerely,
Draksharamam Kumar Mandavilli
mdkumarz@gmail.com ,
91-8121308768
This is the website link for knowing the good reasons behind our
rituals.
http://hindu-
--
Yours sincerely,
Draksharamam Kumar Mandavilli
mdkumarz@gmail.
91-8121308768
Tidak ada komentar:
Posting Komentar