Thanks All for looking at my question,
I have a user who is trying to do the following and he explains his issues
1. Files seem to take much longer to open than previously. Even files that are not large.
2. Today’s issue was in excel I was trying to copy a formula to 36,000 rows in a 16mb file. I turned formula calculation off and each time I tried to do this for more than 1,000 excel would lock up. The formula was complicated but with calc turned off I could not understand the issue.
3. When trying to figure out why I was processing so slow I open task manager. I close everything I could including outlook and any other back ground processing. But the highest amount of CPU processor memory was 25%. I have done this in the past. And have had excel using 90% of the memory.
He has the following hardware
Dell Latitude E5560 laptop win7, 6gb of memory Intel I5 processor, 600gb HD
I have killed every open program and only left excel open, killed unnecessary process too, like iTunes, bing, etc..
SERVER HPDL380 G7
The excel file is on a file server, that the system memory utilization is only 2.1gb out of 8gb.
I have ran a system diagnostic and all comes back good
CPU-31% NORMAL LOAD
NETWORK-IDLE-0%
DISK- IDLE 38/SEC- DISK IO IS LESS THEN 100(READ/WRITE) PER SECOND ON DISK 0
MEMORY- NORMAL-32%-5587 MB AVAILABLE
. I had the user try to open the document on another laptop a totally different model and it did take a few minutes, but it was shorter in time (under 1 minute). the file size is 18mb
What else could I look at to figure out why it takes so long to copy the data.
Thanks
M.
I have a user who is trying to do the following and he explains his issues
1. Files seem to take much longer to open than previously. Even files that are not large.
2. Today’s issue was in excel I was trying to copy a formula to 36,000 rows in a 16mb file. I turned formula calculation off and each time I tried to do this for more than 1,000 excel would lock up. The formula was complicated but with calc turned off I could not understand the issue.
3. When trying to figure out why I was processing so slow I open task manager. I close everything I could including outlook and any other back ground processing. But the highest amount of CPU processor memory was 25%. I have done this in the past. And have had excel using 90% of the memory.
He has the following hardware
Dell Latitude E5560 laptop win7, 6gb of memory Intel I5 processor, 600gb HD
I have killed every open program and only left excel open, killed unnecessary process too, like iTunes, bing, etc..
SERVER HPDL380 G7
The excel file is on a file server, that the system memory utilization is only 2.1gb out of 8gb.
I have ran a system diagnostic and all comes back good
CPU-31% NORMAL LOAD
NETWORK-IDLE-0%
DISK- IDLE 38/SEC- DISK IO IS LESS THEN 100(READ/WRITE) PER SECOND ON DISK 0
MEMORY- NORMAL-32%-5587 MB AVAILABLE
. I had the user try to open the document on another laptop a totally different model and it did take a few minutes, but it was shorter in time (under 1 minute). the file size is 18mb
What else could I look at to figure out why it takes so long to copy the data.
Thanks
M.
