Re: Excel Slow When Opening Linked Files with VLOOKUP Functions wi

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: JulieD (JulieD_at_hctsReMoVeThIs.net.au)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 23:14:59 +0800

Hi

sorry i've got really no further ideas on this .. hope you find a solution.

Cheers
JulieD

"SkyEyes" <SkyEyes@discussions.microsoft.com> wrote in message
news:C3E4FF3F-7445-4FA1-8C5B-A74BB4A9EFA1@microsoft.com...
> Hi JulieD.....I've tried this and it doesn't seem to make a difference.
> I've
> having some of the clients that have a lot of Vlookups trial this and I'll
> let you know though. It seems to me, this is the same case scenario as
> "XL2000: Linked Files with Lookup Functions Updated Much More Slowly Than
> in
> Earlier Versions of Excel" in the knowledgebase, except that we are
> patched
> past SP3 with all security patches. My question is, did they break this
> again with a security patch or something? This would not be unheard of to
> break something that was once fixed? What do you think. Thanks in advance.
>
> "JulieD" wrote:
>
>> Hi
>>
>> not sure it will make a difference but if the problem is only occuring
>> when
>> opening from a desktop shortcut it might be worth seeing if this is sped
>> up
>> with a workspace shortcut on the desktop instead.
>>
>> open the file, choose file / save workspace ... place this on the
>> desktop.
>> See if opening it this way is quicker than the desktop shortcut of the
>> file.
>> Would be interested to hear the outcome.
>>
>> Cheers
>> JulieD
>>
>> "SkyEyes" <SkyEyes@discussions.microsoft.com> wrote in message
>> news:3B0CA844-1461-411D-B271-0FC5FB1ED8DA@microsoft.com...
>> > We had had a few instances of folks lately having problems with slow
>> > response
>> > opening their excel files from shortcuts on their desktops. When they
>> > originally open the files (maybe linked with 4 other files), but have
>> > VLOOKUP
>> > functions, it is extremely slow. They cannot click the menu or do
>> > anything
>> > for several minutes.
>> >
>> > We are on Windows 2000 SP4. In my testing, it only happens with excel
>> > shortcuts. Opening the file from favorites or opening the file from
>> > within
>> > excel works fine. They mentioned this started happening some time this
>> > year
>> > and are finally fed up with this.. These are people that work in
>> > spreadsheets
>> > all day and need to run from several shortcuts. I found the TID, but
>> > we
>> > already have SP3 with all the latest security patches. I was wondering
>> > possibly if it had something to do with an update, since Office SP1a
>> > should
>> > have taken care of this problem. It I shut off Norton and the
>> > firewall,
>> > it
>> > is still extremely slow.
>> >
>> > I have run FileMon and it just blows my mind to see when I open from a
>> > shortcut how much and how many times it writes out to the pagefil.sys,
>> > compared to a small amount when excel is opened.
>> >
>> > Does anyone have any knowledge of this or ever heard of this. Let me
>> > know.
>> > Thanks.
>>
>>
>>

Quantcast