Excel 2007, Slow to Load and Save

**excel199** · 07-14-2010, 04:04 AM

Hey,

I am working on this excel file in which i am made around 5 sheets and have max 10 rows of data. Though i have formulas on most of the sheets....

My excel is suddenly became very slow and takes literally a minute to save and open. i was wondering if i have done something wrong or made it increase the iterations or have a circular reference error which is not showing up because i havnt done anything that great for it to be so slow....

Any views or info would be appreciated.
(i can upload the file if it is needed)

**romperstomper** · 07-14-2010, 04:20 AM

I think the file would help as I for one didn't follow the last bit of your post.

**santhoshbalaji** · 07-15-2010, 10:25 AM

Can you please upload your file. so that i can help you to resolve it

**Mordred** · 07-16-2010, 02:01 PM

I've noticed that if you are saving onto a flash drive that it takes a fair bit longer than saving it onto a hard drive. Are you saving onto a USB flash drive?

**excel199** · 07-21-2010, 02:11 AM

Hey, Thanks Guys...

The problem was that i had written a macro which would sort from A1 to A1000000. This in effect made the file permanently increase in size from 100kb to 20mb.... as now the sheet one has 1000000 active rows...i think i am going to avoid that in the future... Thanks for all your help....

Also i could not upload the file as 20mb file would time out again and again...

**royUK** · 07-21-2010, 03:05 AM

Originally Posted by santhoshbalaji

Can you please upload your file. so that i can help you to resolve it

Stick to the standard font colour.

**royUK** · 07-21-2010, 03:06 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**excel199** · 07-21-2010, 03:18 AM

[QUOTE=royUK;2347808]Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.[/QUOTE

Hey
sorry i thought i did a fairly good job describing what was wrong in the file.

Again, the file size was huge because of the macro which made all 1000000 rows of excel active. By which i mean that the scroll bar on the right if scrolled down would reach 1000000.

I removed that and deleted the redundant rows which got my file to because small again and fast...

Thanks for the SOLVED thing, i was trying to find how to do that....