Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2007

Tip: Looking for answers? Try searching our database.

Need some help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ZÿRiX - 13 Feb 2007 11:47 GMT
Here is a snip from an e-mail from one of my clients...

Our nurses have an excel folder that has one file for every resident.  Each
file for each resident is updated one time a month.  It is 728kb in size.
The files have quite a few check boxes.  The files are on our network drive.
We have 2 computers that routinely access the files.  Both of these
computers are having a difficult time accessing the files.  It takes 3-4
minutes or more for the file to open.  On all of the other computers the
file opens without difficulty.  But other computers do not routinely access
the file.

and the 2 computers in question have been reloaded with xp pro and office
2000 and where working fine and just started this again lately...

Tia

Signature

        ZÿRiX

tristan.huxley@prox-e-mics.eu - 13 Feb 2007 12:34 GMT
Hi Zyrix,

If you are using VBA for the computers to access these files, I would
suggest looking at the network path file coding, only because if it is
dynamic, (ie; refering to a cell on a worksheet, or a function), it
can sometimes take much longer to open, manipulate, manage and
close...
If this is only specific to these two PC's, then I would suggest that
you get your IT group to ensure that the spec's are the same, and if
that is the case, find a pc that is the same and get it cloned and
loaded onto these two problematic PC's.

The only possible other thing that it might be is if they have a lot
of {array} formulas in it or volatile formulas in it which can in some
instances make a small file harder to manage.

Hope this helps you

> Here is a snip from an e-mail from one of my clients...
>
[quoted text clipped - 14 lines]
> --
>          ZÿRiX
Dave Peterson - 13 Feb 2007 14:12 GMT
First thing I'd try is to clean up the windows temp folder.

Close excel
windows start button|Run
%temp%
is a quick way to get there.

And here are a couple of sites that discuss slow performance.  The first is by
Charles Williams and the second by David McRitchie:

http://www.decisionmodels.com
http://www.mvps.org/dmcritchie/excel/slowresp.htm

If that doesn't help, then the next thing I'd try is to copy a few of those
files to the C: drive--just for testing.  If those files open quicker, then
maybe it's a network problem and you should show the results to your IT folks.

> Here is a snip from an e-mail from one of my clients...
>
[quoted text clipped - 14 lines]
> --
>          ZÿRiX

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.