Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Locking Machine
I have a 2.8ghz P4 with 1.75GB memory & 15gb free hard drive space, running
Windows 2000 & Office 2000. I have opened a new Excel document, and an existing Excel file (13mb, containing 13 columns and 48,606 rows of simple text data). Can anyone please explain why when I select this data and copy it into memory before copying it into the new spreadsheet, Excel runs at 100% cpu usage, takes over 200mb memory and takes half an hour for a 13mb file? If I try the same thing in another product (in this case, I am using sql server 2000, which is installed on this machine), it takes milliseconds, with minimal cpu & memory usage. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Locking Machine
Well,
Excel is not optimized as SQL Server is! And, if you add lots of data file will grow rapidly (I tried to fill 60000 rows and 10 columns with random numbers in range 1000-10000 and it had 80MB!?). And, second thing is the fact that Excel doesn't uses multithreading !!!! (OK, Excel 2007 does!) Try with Excel 2007 and post back! "Mark" wrote in message ... I have a 2.8ghz P4 with 1.75GB memory & 15gb free hard drive space, running Windows 2000 & Office 2000. I have opened a new Excel document, and an existing Excel file (13mb, containing 13 columns and 48,606 rows of simple text data). Can anyone please explain why when I select this data and copy it into memory before copying it into the new spreadsheet, Excel runs at 100% cpu usage, takes over 200mb memory and takes half an hour for a 13mb file? If I try the same thing in another product (in this case, I am using sql server 2000, which is installed on this machine), it takes milliseconds, with minimal cpu & memory usage. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Locking Machine
It may be that Excel is having to use virtual memory for some reason.
There could be a very large number of disk accesses if this is the case. Rather then copying the data to the Clipboard and pasting it into the new workbook, it might be faster to use the Move or Copy Sheet function. (Edit|Move or Copy Sheet, or right-click on a sheet tab and select from the popup dialog.) Mark Lincoln On Sep 27, 11:58 am, Mark wrote: I have a 2.8ghz P4 with 1.75GB memory & 15gb free hard drive space, running Windows 2000 & Office 2000. I have opened a new Excel document, and an existing Excel file (13mb, containing 13 columns and 48,606 rows of simple text data). Can anyone please explain why when I select this data and copy it into memory before copying it into the new spreadsheet, Excel runs at 100% cpu usage, takes over 200mb memory and takes half an hour for a 13mb file? If I try the same thing in another product (in this case, I am using sql server 2000, which is installed on this machine), it takes milliseconds, with minimal cpu & memory usage. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Machine With Two Versions of Excel Installed | Excel Discussion (Misc queries) | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
Excel 2000 is still on my machine after upgrading to 2003. | Setting up and Configuration of Excel | |||
Corrupted Excel file - but on only one machine? | Excel Discussion (Misc queries) | |||
Can a workbook be opened w/out Excel on the host machine?? | Excel Discussion (Misc queries) |