ch12345
asked on
Slow to Open/Save Excel file
My pc runs on Nt workstation. I have a hard time open up a file from Excel. It's about 70K, but takes 3 min to open. I defragged my hard drive and increased my virtual memory without much luck. Other Excel files open/save at reasonable speed.
Any idea?
P166, 48MB
Thanks in advance.
Any idea?
P166, 48MB
Thanks in advance.
Does it work with other spreadsheets as well? Is the spreadsheet on the network or on the hard drive? Have you reinstalled Office recently?
It's a problem only with that document ? How much memory do you have ? And the processor ?
My advice: clear all macros, split your document in smaller parts, use an antivirus (they can eat your memory/speed)
My advice: clear all macros, split your document in smaller parts, use an antivirus (they can eat your memory/speed)
ASKER
What's with Macro? Will it slow down the process of opening and saving? WHY?
This is an employee's spreadsheet -- not really mine. He encountered this problem and decided to ask me when we ran into each other. So, I went through some process like defrag, add extra virtual memory, and delete his temp files. Then I reopened that file (70k) from the network drive which took about 3 minutes. Other files at the same network location could be opened in less than 15 seconds.
I then tried to save this file on the hard drive and open it from there. Still the same -- 3 or more minutes. I checked the Performace on Windows Managers, the CPU and Mem Usage spiked up really high when that file was in the process of opening.
I should add that this file was converted from Lotus 123 to Excel. Could this be the problem?
This is an employee's spreadsheet -- not really mine. He encountered this problem and decided to ask me when we ran into each other. So, I went through some process like defrag, add extra virtual memory, and delete his temp files. Then I reopened that file (70k) from the network drive which took about 3 minutes. Other files at the same network location could be opened in less than 15 seconds.
I then tried to save this file on the hard drive and open it from there. Still the same -- 3 or more minutes. I checked the Performace on Windows Managers, the CPU and Mem Usage spiked up really high when that file was in the process of opening.
I should add that this file was converted from Lotus 123 to Excel. Could this be the problem?
After the conversion is the file save in the new excel version...
Mario
Mario
This might sound silly, but rename the file, then open it. I've used this as a solution a few times, and it works.
Have you tried copying the worksheets to a new workbook or pasting the data to a new workbook?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
have you had a machine go offline recently? or run any programs off another machine that may be off?
i had the same problem,
we had decommissioned a copule servers, and they used to have programs running on those servers, and whenever a file is opened from the local computer, it looks for the files on that server.
i just went through my registry and deleted all the entries for that server, and it fixed all the problems.
i had the same problem,
we had decommissioned a copule servers, and they used to have programs running on those servers, and whenever a file is opened from the local computer, it looks for the files on that server.
i just went through my registry and deleted all the entries for that server, and it fixed all the problems.
Did you have turn on your page break (and are the visible)?
Did this sheet have a password?
Mario