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.
Who is Participating?
TooKoolKrisConnect With a Mentor Commented:
Don't open the file from across the network. I always tell my users to copy the file to their C drives and open it from their, much quicker. Also increasing the Virtual Mem doesn't enhance performance it may even cause it to decrease. As a pointer keep your paging file about 15mb over the amount of actual RAM in the Pc.
Is there a macro in it?

Did you have turn on your page break (and are the visible)?

Did this sheet have a password?

Does it work with other spreadsheets as well?  Is the spreadsheet on the network or on the hard drive?  Have you reinstalled Office recently?
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

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)
ch12345Author Commented:
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?
After the conversion is the file save in the new excel version...

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?
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.

All Courses

From novice to tech pro — start learning today.