8 Messages
Digest #3185
Messages
Fri Sep 19, 2014 7:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Looks like it's back to normal today?
On Thu, Sep 18, 2014 at 10:07 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I just noticed that my spreadsheet is now giving me an error message for
> the zack numbers.
>
> I just went to their website and entered, as an example , the ticker 'T'
> and saw this at their website in the top right corner:
>
> At&t Inc: (T) (Delayed quote from: NYSE) As of Sep 19, 2014 12:04 AM ET
>
> Add to portfolio
> ZacksTrade Now <http://www.zacks.com/stock/quote/T?q=t#>
>
> $35.16 USD
>
> +0.14 (0.40%)
>
> Volume: 17,236,314
>
> Zacks Rank : NA [?]
>
>
On Thu, Sep 18, 2014 at 10:07 PM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I just noticed that my spreadsheet is now giving me an error message for
> the zack numbers.
>
> I just went to their website and entered, as an example , the ticker 'T'
> and saw this at their website in the top right corner:
>
> At&t Inc: (T) (Delayed quote from: NYSE) As of Sep 19, 2014 12:04 AM ET
>
> Add to portfolio
> ZacksTrade Now <http://www.zacks.com/stock/quote/T?q=t#>
>
> $35.16 USD
>
> +0.14 (0.40%)
>
> Volume: 17,236,314
>
> Zacks Rank : NA [?]
>
>
Fri Sep 19, 2014 9:39 am (PDT) . Posted by:
zbgb952
Appears that way. I also noticed that the Zack's rating is back on their website for each stock in the top right corner.
Fri Sep 19, 2014 11:59 am (PDT) . Posted by:
shhutchens6
That's probably what it is. Ill just have to wait and see if or when it comes back. thanks for the info.
I'm having no problems with Zack Ranks. I have a spreadsheet with
about 20 tickers
-----Original Message-----
From: "shhutchens6@yahoo.com [smf_addin]"
Sent: Sep 19, 2014 3:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Zacks rank
That's probably what it is. Ill just have to wait and see if or
when it comes back. thanks for the info.
about 20 tickers
-----Original Message-----
From: "shhutchens6@yahoo.com [smf_addin]"
Sent: Sep 19, 2014 3:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Zacks rank
That's probably what it is. Ill just have to wait and see if or
when it comes back. thanks for the info.
Fri Sep 19, 2014 2:23 pm (PDT) . Posted by:
friedman_steve
I have an excel file with SMF formulas on Computer A. The same file can be accessed by Computer B on a network. When Computer B opens it, the computer asks that the links be updated to B's version of the SMF add-in. If B redirects to the proper xla file, then spreadsheet updates correctly and works.
But, then when computer A opens it... now A has to update the xla file. So this becomes a recurring nuisance when sharing file back & forth.
Is there an elegant solution to solve this problem? I tried putting the xla file into the same shared drive and having A & B reference the same file, but this didn't work. (seems like each computer just copies onto its local drive or something).
Any suggestions would be great. The SMF tools is awesome and we're very thankful!
Thanks,
Steve
But, then when computer A opens it... now A has to update the xla file. So this becomes a recurring nuisance when sharing file back & forth.
Is there an elegant solution to solve this problem? I tried putting the xla file into the same shared drive and having A & B reference the same file, but this didn't work. (seems like each computer just copies onto its local drive or something).
Any suggestions would be great. The SMF tools is awesome and we're very thankful!
Thanks,
Steve
Fri Sep 19, 2014 2:47 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure there is a resolution, because I think it's EXCEL that won't
resolve the links across a network? What does the hard-coded location look
like -- does it use a mapped drive, or a hardware direction of some type?
Are you using the smfFixLinks macro? That's the easiest thing I can think
of to fix it each time. Hmm. Does it even work on a network location? If it
becomes too much of a nuisance, you could try making that something that is
automatically executed when the workbook is opened...
On Fri, Sep 19, 2014 at 2:23 PM, friedman_steve@...wrote:
> I have an excel file with SMF formulas on Computer A. The same file can
> be accessed by Computer B on a network. When Computer B opens it, the
> computer asks that the links be updated to B's version of the SMF add-in.
> If B redirects to the proper xla file, then spreadsheet updates correctly
> and works.
>
> But, then when computer A opens it... now A has to update the xla file.
> So this becomes a recurring nuisance when sharing file back & forth.
>
> Is there an elegant solution to solve this problem? I tried putting the
> xla file into the same shared drive and having A & B reference the same
> file, but this didn't work. (seems like each computer just copies onto its
> local drive or something).
>
> Any suggestions would be great. The SMF tools is awesome and we're very
> thankful!
>
>
resolve the links across a network? What does the hard-coded location look
like -- does it use a mapped drive, or a hardware direction of some type?
Are you using the smfFixLinks macro? That's the easiest thing I can think
of to fix it each time. Hmm. Does it even work on a network location? If it
becomes too much of a nuisance, you could try making that something that is
automatically executed when the workbook is opened...
On Fri, Sep 19, 2014 at 2:23 PM, friedman_steve@
> I have an excel file with SMF formulas on Computer A. The same file can
> be accessed by Computer B on a network. When Computer B opens it, the
> computer asks that the links be updated to B's version of the SMF add-in.
> If B redirects to the proper xla file, then spreadsheet updates correctly
> and works.
>
> But, then when computer A opens it... now A has to update the xla file.
> So this becomes a recurring nuisance when sharing file back & forth.
>
> Is there an elegant solution to solve this problem? I tried putting the
> xla file into the same shared drive and having A & B reference the same
> file, but this didn't work. (seems like each computer just copies onto its
> local drive or something).
>
> Any suggestions would be great. The SMF tools is awesome and we're very
> thankful!
>
>
Fri Sep 19, 2014 2:49 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I use an external hard drive that is on 3rd system which is define on all other systems as the same drive. When I am first developing a spreadsheet then I have it on whichever machine I am on.
However, once it has been completed I place it on a computer which sort of act as a remote server. I have a total of 5 computer al on the same Local network.
So buy yourself a 3rd machine and use it like a server.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, September 19, 2014 5:24 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Problem using SMF across two networked computers
I have an excel file with SMF formulas on Computer A. The same file can be accessed by Computer B on a network. When Computer B opens it, the computer asks that the links be updated to B's version of the SMF add-in. If B redirects to the proper xla file, then spreadsheet updates correctly and works.
But, then when computer A opens it... now A has to update the xla file. So this becomes a recurring nuisance when sharing file back & forth.
Is there an elegant solution to solve this problem? I tried putting the xla file into the same shared drive and having A & B reference the same file, but this didn't work. (seems like each computer just copies onto its local drive or something).
Any suggestions would be great. The SMF tools is awesome and we're very thankful!
Thanks,
Steve
However, once it has been completed I place it on a computer which sort of act as a remote server. I have a total of 5 computer al on the same Local network.
So buy yourself a 3rd machine and use it like a server.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, September 19, 2014 5:24 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Problem using SMF across two networked computers
I have an excel file with SMF formulas on Computer A. The same file can be accessed by Computer B on a network. When Computer B opens it, the computer asks that the links be updated to B's version of the SMF add-in. If B redirects to the proper xla file, then spreadsheet updates correctly and works.
But, then when computer A opens it... now A has to update the xla file. So this becomes a recurring nuisance when sharing file back & forth.
Is there an elegant solution to solve this problem? I tried putting the xla file into the same shared drive and having A & B reference the same file, but this didn't work. (seems like each computer just copies onto its local drive or something).
Any suggestions would be great. The SMF tools is awesome and we're very thankful!
Thanks,
Steve
Fri Sep 19, 2014 3:15 pm (PDT) . Posted by:
"Brad Reel" reeldeal9090
I have a file on a thumb drive, and use the thumb drive on two different
computers. Both computers have the add-in.
On both computers, the thumb drive maps as E:, so in both cases, the add in
is in the same location relative to the file. Also, and this is probably
more important as I think about it, you must have the add-in stored in the
same location on both computers (i.e. something like C:\program files\SMF
Add in).
I suggest trying to store the file somewhere on your network and make sure
wherever it is stored is mapped as the same network drive on both
computers. If that doesn't work, I don't have any other ideas.
On Fri, Sep 19, 2014 at 4:23 PM, friedman_steve@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> I have an excel file with SMF formulas on Computer A. The same file can
> be accessed by Computer B on a network. When Computer B opens it, the
> computer asks that the links be updated to B's version of the SMF add-in.
> If B redirects to the proper xla file, then spreadsheet updates correctly
> and works.
>
> But, then when computer A opens it... now A has to update the xla file.
> So this becomes a recurring nuisance when sharing file back & forth.
>
>
> Is there an elegant solution to solve this problem? I tried putting the
> xla file into the same shared drive and having A & B reference the same
> file, but this didn't work. (seems like each computer just copies onto its
> local drive or something).
>
>
> Any suggestions would be great. The SMF tools is awesome and we're very
> thankful!
>
>
> Thanks,
>
> Steve
>
>
>
computers. Both computers have the add-in.
On both computers, the thumb drive maps as E:, so in both cases, the add in
is in the same location relative to the file. Also, and this is probably
more important as I think about it, you must have the add-in stored in the
same location on both computers (i.e. something like C:\program files\SMF
Add in).
I suggest trying to store the file somewhere on your network and make sure
wherever it is stored is mapped as the same network drive on both
computers. If that doesn't work, I don't have any other ideas.
On Fri, Sep 19, 2014 at 4:23 PM, friedman_steve@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> I have an excel file with SMF formulas on Computer A. The same file can
> be accessed by Computer B on a network. When Computer B opens it, the
> computer asks that the links be updated to B's version of the SMF add-in.
> If B redirects to the proper xla file, then spreadsheet updates correctly
> and works.
>
> But, then when computer A opens it... now A has to update the xla file.
> So this becomes a recurring nuisance when sharing file back & forth.
>
>
> Is there an elegant solution to solve this problem? I tried putting the
> xla file into the same shared drive and having A & B reference the same
> file, but this didn't work. (seems like each computer just copies onto its
> local drive or something).
>
>
> Any suggestions would be great. The SMF tools is awesome and we're very
> thankful!
>
>
> Thanks,
>
> Steve
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar