Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Everytime I try to access Excel, my cpu is pegged


  • Please log in to reply

#1
Namflow

Namflow

    Member

  • Member
  • PipPip
  • 61 posts
Everytime I try to access one of my excel spreadsheets, my computer locks and my cpu is pegged to 100%. This just started happening about 3 weeks ago. I have no idea why or how I can fix it. My computer will lock for a little while which is extremely frustrating. Anyone have any ideas or suggestions?

Thanks in advance
  • 0

Advertisements


#2
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
Hello Namflow,

Is it only one of your spreadsheets that this is happening in? Many times I've noticed that Excel will take a long time to load a document if you already have another document opened. Please give us some more details.

Regards,

Ax
  • 0

#3
Namflow

Namflow

    Member

  • Topic Starter
  • Member
  • PipPip
  • 61 posts
Hi Ax,

I usually have outlook, quickbooks, and IE open along with aim running in the background. This is the only excel spreadsheet that I use on a daily basis.

The pc is a pentium 4 with 512 ram.

Thanks

josh
  • 0

#4
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
Is the spreadsheet configured to run some macros on startup? Does the same thing happen if you open a different spreadsheet?

If it's just in that one file, you can try the Excel Workbook Rebuilder. It's a two-week trial, but you should be able to fix any problems with it.

Regards,

Ax
  • 0

#5
Namflow

Namflow

    Member

  • Topic Starter
  • Member
  • PipPip
  • 61 posts
Thanks Ax- I will try this at work on Monday!
  • 0

#6
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
:) No problem, let me know how it goes.
  • 0

#7
Namflow

Namflow

    Member

  • Topic Starter
  • Member
  • PipPip
  • 61 posts
tried it but no luck....the excel spreadsheet constantly locks up (not responding). Could it be a virus? Could I have too much information in the spreadsheet?
  • 0

#8
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts

Is the spreadsheet configured to run some macros on startup? Does the same thing happen if you open a different spreadsheet?


Also, how much data is in the spreadsheet? Does it open if you wait long enough? If so, can you copy the data into a new spreadsheet?
  • 0

#9
Namflow

Namflow

    Member

  • Topic Starter
  • Member
  • PipPip
  • 61 posts
I have about 75 different pages. This is my quote book. Everytime I quote a customer a price, it gets entered. Each page is a different customer. When I open the book it stalls. When I select all sheets to search, it stalls. Eventually it gets up to speed but it takes 5-10 minutes and locks my computer when doing this.
  • 0

#10
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
Wow, that does sound like a big spreadsheet. Take a look at the following link to see if it helps:
Slow Response, Memory Problems, and Speeding up Excel

Also, are you familiar with Access? I'm thinking a database approach might actually be better for what you are doing. Have you ever considered changing the storage format for your data?
  • 0

#11
Namflow

Namflow

    Member

  • Topic Starter
  • Member
  • PipPip
  • 61 posts
what is access? Is it part of msft 2003 office?
  • 0

#12
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
Microsoft Access - Wikipedia, the free encyclopedia

It depends on which version of MS Office 2003 you have. It comes bundled with the Professional Edition.
  • 0

#13
Namflow

Namflow

    Member

  • Topic Starter
  • Member
  • PipPip
  • 61 posts
I have msft office pro 2003 and it came with access. I looked at the program yesterday but honestly have no idea how to use it. I will look for some free tutorials on the web today. Thanks.
  • 0

#14
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
Hey no problem, if you wanted me to help you set it up, I'd be more than willing. I'm going to be busy until the end of the holiday season, but after that I can look into it for you. You'll just need to send me your spreadsheet. Otherwise, good luck :)!
  • 0

#15
Namflow

Namflow

    Member

  • Topic Starter
  • Member
  • PipPip
  • 61 posts
I would love to take you up on your offer if it is still on the table. let me know when you have some free time to discuss.

Thanks
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP