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.
ch12345Asked:
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.
0
 
LermitteCommented:
Is there a macro in it?

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

Did this sheet have a password?

Mario
0
 
ccarrollCommented:
Does it work with other spreadsheets as well?  Is the spreadsheet on the network or on the hard drive?  Have you reinstalled Office recently?
0
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!)

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

Mario
0
 
asaboCommented:
This might sound silly, but rename the file, then open it.  I've used this as a solution a few times, and it works.  
0
 
pyleoCommented:
Have you tried copying the worksheets to a new workbook or pasting the data to a new workbook?
0
 
b8conCommented:
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.

0
All Courses

From novice to tech pro — start learning today.