Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Elton Seng Yan Thung
 
Posts: n/a
Default Excel 2003 Slowness problem in Windows XP

Dear expert,
I wish to get your help to solve the problem happened in our organization.
A group of users who are heavy user of Excel, complaint that after computer
upgraded to Windows XP SP1 (Pentium 4, 256MB Ram) and Office 2003 STD SP1,
excel file tend to be slower when the computer running Winnt, office 97.
After study and find out not all the excel file opening are slow in their
PC. These most frequently access excel files that causing slowness are
either too many formula, macro enable or too many sheet. File side about
2MB-4MB. I have advised them to reduce number of sheet, formula and macro
used in a single file. However they couldn't due to function of job.
I had tried installed WinXP SP2 with additional (from 256MD to 512MB)
memory, the improvement is not there. The strange thing is, I have installed
Win2k SP4 with Office 2003 STD SP1, all files tend to open 3 time faster
than in Windows XP. The machine is a Pentium 3 256MB Ram. The office
installed are same package, same template and same option with other users.
Since all Windows XP are from same clone, I suspect some thing wrong
with the OS image. But I couldn't find any suspicious service, function on
in these PC.
Users are waiting for my solution but I am not totally out of mind. Thus
if anyone has worked across the same problem, please share your experience
with us.

thanks a lot


  #2   Report Post  
Michael_Corral
 
Posts: n/a
Default

It is also quite possible that some of those files are from even more
previous versions of Excel. One work around is to copy the data and paste,
paste special if you can, into a new worksheet and save then delete the old.
Repeat this step with the Macros. I know this will work, but will take
sometime, but it will work.


--
Top Notch Admin


"Elton Seng Yan Thung" wrote:

Dear expert,
I wish to get your help to solve the problem happened in our organization.
A group of users who are heavy user of Excel, complaint that after computer
upgraded to Windows XP SP1 (Pentium 4, 256MB Ram) and Office 2003 STD SP1,
excel file tend to be slower when the computer running Winnt, office 97.
After study and find out not all the excel file opening are slow in their
PC. These most frequently access excel files that causing slowness are
either too many formula, macro enable or too many sheet. File side about
2MB-4MB. I have advised them to reduce number of sheet, formula and macro
used in a single file. However they couldn't due to function of job.
I had tried installed WinXP SP2 with additional (from 256MD to 512MB)
memory, the improvement is not there. The strange thing is, I have installed
Win2k SP4 with Office 2003 STD SP1, all files tend to open 3 time faster
than in Windows XP. The machine is a Pentium 3 256MB Ram. The office
installed are same package, same template and same option with other users.
Since all Windows XP are from same clone, I suspect some thing wrong
with the OS image. But I couldn't find any suspicious service, function on
in these PC.
Users are waiting for my solution but I am not totally out of mind. Thus
if anyone has worked across the same problem, please share your experience
with us.

thanks a lot



  #3   Report Post  
Elton Seng Yan Thung
 
Posts: n/a
Default

thanks, it work in one of the tested file.
regards
"Michael_Corral" wrote in message
...
It is also quite possible that some of those files are from even more
previous versions of Excel. One work around is to copy the data and
paste,
paste special if you can, into a new worksheet and save then delete the
old.
Repeat this step with the Macros. I know this will work, but will take
sometime, but it will work.


--
Top Notch Admin


"Elton Seng Yan Thung" wrote:

Dear expert,
I wish to get your help to solve the problem happened in our
organization.
A group of users who are heavy user of Excel, complaint that after
computer
upgraded to Windows XP SP1 (Pentium 4, 256MB Ram) and Office 2003 STD
SP1,
excel file tend to be slower when the computer running Winnt, office 97.
After study and find out not all the excel file opening are slow in
their
PC. These most frequently access excel files that causing slowness are
either too many formula, macro enable or too many sheet. File side about
2MB-4MB. I have advised them to reduce number of sheet, formula and macro
used in a single file. However they couldn't due to function of job.
I had tried installed WinXP SP2 with additional (from 256MD to 512MB)
memory, the improvement is not there. The strange thing is, I have
installed
Win2k SP4 with Office 2003 STD SP1, all files tend to open 3 time faster
than in Windows XP. The machine is a Pentium 3 256MB Ram. The office
installed are same package, same template and same option with other
users.
Since all Windows XP are from same clone, I suspect some thing wrong
with the OS image. But I couldn't find any suspicious service, function
on
in these PC.
Users are waiting for my solution but I am not totally out of mind.
Thus
if anyone has worked across the same problem, please share your
experience
with us.

thanks a lot





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
quattro pro converter Excel 2003 dr88363 New Users to Excel 0 February 27th 05 06:00 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 08:27 PM
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 06:33 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM


All times are GMT +1. The time now is 07:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"