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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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
TooKoolKrisCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Networking

From novice to tech pro — start learning today.