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

Excel 2003 Problem


  • Please log in to reply

#1
rsa

rsa

    Member

  • Member
  • PipPip
  • 18 posts
I am having problem with excel 2003 for this certain filename. The size is about 3MB file. Everytime I open this file it would takes long time to open this and switching from one tabe to another would take several seconds or minutes at time. It will undergo not responding before it will go back to normal again. Can someone tell me what should I do with this?
  • 0

Advertisements


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Hi

Have you tried File > Save as > save the file to a new name

Does the new file also take a long time to open?
  • 0

#3
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts
How many formulae?

If there's a lot of formluae you could try switcing from automatic calculation to manual and see if that makes any difference.

Are there many/any links to external spreadsheets? If so, do the files live on a different server?

Cell formatting can use up a LOT of memory - esoteric formats could slow your pc to a crawl when it's trying to do screen refreshes.

Any auto-open macros running?
  • 0

#4
rsa

rsa

    Member

  • Topic Starter
  • Member
  • PipPip
  • 18 posts

How many formulae? It has plenty of formula I have about more than 10 sheets in it and they are interlinked with each other

If there's a lot of formluae you could try switcing from automatic calculation to manual and see if that makes any difference. I've tried it and somehow it worked for me but it still is slow and would not resposnd for sometime before coming back to normal

Are there many/any links to external spreadsheets? If so, do the files live on a different server? It is saved in my local PC only and no linke to external spreadsheets

Cell formatting can use up a LOT of memory - esoteric formats could slow your pc to a crawl when it's trying to do screen refreshes.I do have some cell formatting and conditional formatting in there but very few

Any auto-open macros running? I have not created any macro in that sheet



Plese find my response in red..... Thanks!!
  • 0

#5
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts

How many formulae? It has plenty of formula I have about more than 10 sheets in it and they are interlinked with each other

If there's a lot of formluae you could try switcing from automatic calculation to manual and see if that makes any difference. I've tried it and somehow it worked for me but it still is slow and would not resposnd for sometime before coming back to normal

Are there many/any links to external spreadsheets? If so, do the files live on a different server? It is saved in my local PC only and no linke to external spreadsheets

Cell formatting can use up a LOT of memory - esoteric formats could slow your pc to a crawl when it's trying to do screen refreshes.I do have some cell formatting and conditional formatting in there but very few

Any auto-open macros running? I have not created any macro in that sheet



Plese find my response in red..... Thanks!!


Yeah - try removing the conditional formatting, save as a new file and see if that makes any difference.
Conditional formatting is a huge memory hog.

You say there's over 10 sheets, how many more? Another 10? 100?

How many rows/columns in each sheet?
  • 0

#6
rsa

rsa

    Member

  • Topic Starter
  • Member
  • PipPip
  • 18 posts

How many formulae? It has plenty of formula I have about more than 10 sheets in it and they are interlinked with each other

If there's a lot of formluae you could try switcing from automatic calculation to manual and see if that makes any difference. I've tried it and somehow it worked for me but it still is slow and would not resposnd for sometime before coming back to normal

Are there many/any links to external spreadsheets? If so, do the files live on a different server? It is saved in my local PC only and no linke to external spreadsheets

Cell formatting can use up a LOT of memory - esoteric formats could slow your pc to a crawl when it's trying to do screen refreshes.I do have some cell formatting and conditional formatting in there but very few

Any auto-open macros running? I have not created any macro in that sheet



Plese find my response in red..... Thanks!!


Yeah - try removing the conditional formatting, save as a new file and see if that makes any difference.
Conditional formatting is a huge memory hog. Thanks I will try that when I come back to work. I also have noticed that my sheets were all in page preview mode. I tried removing that too in normal mode and the size has somehow lessened already.

You say there's over 10 sheets, how many more? Another 10? 100? about 15 sheets in all

How many rows/columns in each sheet? I really did not take noticed of it but as far as I remember it did not passed through column "Z" rows was much longer it reach about 500-700 rows in each sheet.


  • 0

#7
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts
In my opinion, removing the page preview and conditional formatting should speed it up considerably, depending ultimately on your machine of course!!

Good luck.
  • 0

#8
rsa

rsa

    Member

  • Topic Starter
  • Member
  • PipPip
  • 18 posts

In my opinion, removing the page preview and conditional formatting should speed it up considerably, depending ultimately on your machine of course!!

Good luck.



Yes it did improved in the speed, its actually slow still but the opening and closing has improved already significantly and the crashing of the sheet was eliminated already Thank your very much.
  • 0

#9
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts
You're welcome.
  • 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