Re: User complaining

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On 5/18/2007 1:34 PM On a whim, smlunatick pounded out on the keyboard

On May 18, 3:57 pm, Chuck <charlesamo...@xxxxxxxxx> wrote:
On 18 mai, 15:55, Chuck <charlesamo...@xxxxxxxxx> wrote:





On 18 mai, 15:31, smlunatick <yves...@xxxxxxxxx> wrote:
On May 18, 11:02 am, "Ron P" <s...@xxxxxxxx> wrote:
"Chuck" <charlesamo...@xxxxxxxxx> wrote in message
news:1179495226.896997.259370@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi everybody,
Does someone has a trick for speeding up computers ? I use a program
call Windows Cleanup !
It erase all the recent files, cookies... and after that I do a
defrag. But he still complaining. That guy has a xeon (2 processor)
and 2 gig of ram. He has a 10 K hard drive. So I don't really know
what to do to make him happy.
He is using Excel all day long... but it's generally a 90 000 line
file.
Thanks for all your help
I don't know what you mean by a 10K hard drive but I am thinking that you
are referring to a very large hard drive and not a very small one which 10K
would be.
The problem probably lies with his spreadsheet. It might be 90,000 rows long
but how many columns are there and what calculations are being made and how
complex are these calculations? His set-up for how calculations are done in
the options for Excel can greatly affect performance. If set to auto, every
time he adds data that requires a calculation, the whole sheet
re-calculates.
Just because there are more than 65,000 rows and about 250 columns it
doesn't mean that every cell can be crammed with information like sardines
in a can and still operate. I would think it would be more productive to
see if your clients methodology in using Excel isn't the source of his
problems.
Also, some people are just never satisfied no matter what you do.....is he
one of them?
10K -- !0,0000 RPM (revolutions per minute.) Usually a SCSI based
hard drive
Also, if the PC has two XEON processors, the version of XP should be
Professional as it is really the only version of XP that can use two
physical processors.- Masquer le texte des messages précédents -
- Afficher le texte des messages précédents -
Yes that is what he got in his computer. I'm still looking for
something that can tune up Xp. I don't know if someone has some trick
to speed it up (not hardware, but software). Thanks- Masquer le texte des messages précédents -
- Afficher le texte des messages précédents -
I mean it is not a scsi, it's a sata disk.- Hide quoted text -

- Show quoted text -

SATA 1 = Ultra150 speeds
SATA II = 3G speeds

You need to look at what applications / processes / services are set
up to automatically start up and turn "most" off, depending on their
importance and his needs. Also, you need to boost the RAM more as the
problem could be related to the sheer size of the Excel sheet. It may
be too large for the system to process in RAM only.



RPM's have nothing to do with whether it's SATA I or II. While 7200 rpm may be common, there are 10k drives out there. Where have you been?

--
Terry

***Reply Note***
Anti-spam measures are included in my email address.
Delete NOSPAM from the email address after clicking Reply.
.

Relevant Pages

  • Re: User complaining
    ... Does someone has a trick for speeding up computers? ... He is using Excel all day long... ... but how many columns are there and what calculations are being made and how ... You can use MSCONFIG to see what is loading, ...
    (microsoft.public.windowsxp.general)
  • Re: Add more lines and more columns in Excel
    ... >Altought I can understand that in the days of the Intel 286, the computers ... MatLab, Octave, SciLab, Gauss for other massive calculations), those ... packages are often the better choice than Excel ... I'm much happier myself using other packages instead of Excel to ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Auto run excel calculations in background - Help!
    ... A standard module is one of those you will see when you select Modules from ... specific to a form or report. ... calculations one time and then use that data in multiple ways, ... of columns in an Excel Spreadsheet. ...
    (microsoft.public.access.externaldata)
  • RE: Auto run excel calculations in background - Help!
    ... calculations, then I set up the calculations in control boxes within the ... I'm only going to display the summary data in the report, ... If I run the calculations in the report instead of the query would I ... of columns in an Excel Spreadsheet. ...
    (microsoft.public.access.externaldata)
  • Re: INT defect: Please try this on 2007 for me
    ... binary floating point representation and calculations. ... the low-order bits you should not be using Excel. ... as 40000.847999999 when formatted to 15 significant digits. ...
    (microsoft.public.excel.worksheet.functions)