3 New Messages
Digest #2334
| |
Messages
Fri Aug 31, 2012 9:41 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Did you exit and restart EXCEL or run the smfForceRecalculation macro, or
try a different ticker symbol?
Otherwise, it will just be extracting data from the originally retrieved
and saved web page. The add-in saves web pages and extracts data from the
saved copy of the web page, so that multiple items from the same web page
only require a single Internet access. So, once you log in, you need the
add-in to purge that originally saved web page and get a fresh copy.
On Fri, Aug 31, 2012 at 9:20 PM, Lei Liao <liaolei78@gmail.com > wrote:
>
> Hi Randy, I tried logging in thru excel web query, and nothing changed.
>
> Here is what I did:
>
> 1. I opened a new web query
> 2. I typed the www. morningstar.com in the address
> 3. I logged in as a premium account holder
>
> Is there anything else I still need to do to get the data on
> premium account to be shown in excel?
>
>
try a different ticker symbol?
Otherwise, it will just be extracting data from the originally retrieved
and saved web page. The add-in saves web pages and extracts data from the
saved copy of the web page, so that multiple items from the same web page
only require a single Internet access. So, once you log in, you need the
add-in to purge that originally saved web page and get a fresh copy.
On Fri, Aug 31, 2012 at 9:20 PM, Lei Liao <liaolei78@gmail.
>
> Hi Randy, I tried logging in thru excel web query, and nothing changed.
>
> Here is what I did:
>
> 1. I opened a new web query
> 2. I typed the www. morningstar.
> 3. I logged in as a premium account holder
>
> Is there anything else I still need to do to get the data on
> premium account to be shown in excel?
>
>
Fri Aug 31, 2012 9:58 pm (PDT) . Posted by:
"Lei Liao" leiliao78@ymail.com
Thanks Randy, it works now.
Really appreciated, have a good weekend.
Best,
Lei
Really appreciated, have a good weekend.
Best,
Lei
Fri Aug 31, 2012 9:51 pm (PDT) . Posted by:
"PLA" option2z
Just guessing, but I've had some where the "Conditional Formatting" goes
haywire. I look at all the formulas in "Manage Rules" and find some of them
have screwy references. Easy to check.
RE:
<mailto:billsadek@gmail.com ?subject=Re%3A%20Very%20slow%20opening%20and%20sa
ving%20some%20files> "billsadek" billsadek
I have Windows 7 and MS Office 2007. When I open or save some files they are
very slow to load. For example one file keeps track of all my options
trades, it has about 10 tabs, 5 small pivot tables and no macros. Another
file has only two tabs, no pivot tables and no macros. On the other hand,
some other files I have open and save with no problems!
I have 6 GB of RAM and Intel Pentium i5 processor. Any help or ideas would
be greatly appreciated. I am going crazy... :(
Pete A
Amateurs practice until they get it right, experts practice until they can't
get it wrong
(Faith Duck)
haywire. I look at all the formulas in "Manage Rules" and find some of them
have screwy references. Easy to check.
RE:
<mailto:billsadek@gmail.
ving%20some%
I have Windows 7 and MS Office 2007. When I open or save some files they are
very slow to load. For example one file keeps track of all my options
trades, it has about 10 tabs, 5 small pivot tables and no macros. Another
file has only two tabs, no pivot tables and no macros. On the other hand,
some other files I have open and save with no problems!
I have 6 GB of RAM and Intel Pentium i5 processor. Any help or ideas would
be greatly appreciated. I am going crazy... :(
Pete A
Amateurs practice until they get it right, experts practice until they can't
get it wrong
(Faith Duck)
Tidak ada komentar:
Posting Komentar