[rsa]

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?

[Advertisements]

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?

[Vino Rosso]

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?

[Jonesey]

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?

[rsa]

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!!

[Jonesey]

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?

[rsa]

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.

[Jonesey]

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

Good luck.

[rsa]

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.

[Jonesey]

You're welcome.