Computer wizards - why is Excel now painfully slow?

Roxy's Mum

New Member
Jul 21, 2009
4,318
2
0
Dorset
I'm not much of a computer wizard so hoping somebody on here can help.

I run a weekly report of costs and the spreadsheet I use is becoming slower & slower to the point of driving me to tears.

There are 5 tabs in total, 3 of them just hold data copy & pasted from a separate spreadsheet. The other two tabs are graphs.

When the spreadsheet was first used it worked fine but now it's so slow it's taken me half a day to do only half of my report, which should take 1/2 hour max :banghead:

Is it because there is a lot of copy & paste involved it layers the data? Am I best to delete the old data & then paste into the cells?

How can I speed it up before it drives me over the edge? :help:
 
I am that sad person at work who gets all the excel queries....i want the i heart excel mug lol :smile:

Not sure about this one tho...we have some pretty huge spreadsheets and not running slow. Is it set to shared use as thats the only time we've ever had time problems.

What size is the file in KB??? could you archive any of the data to split the sheet if it is huge???
 
Excel can be funny about memory usage. Sometimes it doesn't release the memory it used before and it gets slower and slower.

Try doing your cut and paste then shut all your Excel spreadsheets down and open the one you want to work in.

The other possibility is that there is a loop or mistake in one of the cells that is slowing everything down.

Does this happen on another machine? It could be a problem with the PC itself.
 
We use some big spreadsheets at work which have lots of formulae in and are painfully slow on our rather old PCs. The only way we can work with them is by turning automatic calculation off, until we've finished doing what we're doing and then either hitting F9 to refresh all the calculations or turning automatic calculation back on. Not sure whether this could be your problem as the workbook doesn't sound that big. If you want to give it a try in Excel 2007 go into your Office button (top left), Excel Options (at the bottom), choose Formulas from the menu at the left and then select 'Manual' in the top section.

In previous versions it's in Tools, Options and I think there's a tab for calculations.

All it does is stop the workbook calculating the formulas every time you make a change to a cell, so you have to remember to turn it back on, or hit F9 to update all the calculations when you've finished making all your changes (or F2 will calculate a single cell). When you turn it back on it will take a while for the workbook to do its thing but at least you only have to wait the once.
 
Ooh heck okay - I'll see what I can do! I'll maybe save it to my desktop first and use that to play around with, rather than make an epic fail on the master copy.

It's not a shared spreadsheet, only I use it although sometimes my manager will go into it if there's a problem with the macros (which sometimes have a life of their own & he has to rewrite them). It's not shared & nobody else uses it at all. My manager has the same problem when he tries to use it so it's not my PC causing the problem (for once!)

Sometimes I do wish I had a typewriter & a calculator instead!

ETA: File size is 21,628 KB. Is that big?? :unsure:
 
Can you not save a template version (with no data, just eh forumal/macros in, and then each month use that template but save the file under a diferent name so you have a file for each month? Graphs tend to make things heavy too - just like adding pictures does.
 
Can you not save a template version (with no data, just eh forumal/macros in, and then each month use that template but save the file under a diferent name so you have a file for each month? Graphs tend to make things heavy too - just like adding pictures does.

To a degree but half of the data I need is a comparison of last week to this week and a running total. At present the previous week's data stays there & then I add the new data accordingly.

I suppose I could always have a blank master copy then add the data (last & this weeks) as necessary and save a separate spreadsheet for each week. It's just not very Lean that's all!
 
Def a good idea playing about with a copy, could you have the graphs in sepearte sheets and just link or copy the date in ? I do this with our rolling p&l graph, just copy/link (depending on if its the current month or ytd) the relevent data into a tab and the graph on the other tab...means my actual p&l sheets run quickly and update fast even when using vision softwear to extract the info from our finance package.

Hope you figure something out to make it quicker for you :smile:

I hate macros.....
 
It's driving me bloody bananas & chances are it won't even be finished by the end of the day. I'd got to print it all off & PDF it all yet :furious: and I haven't been able to do anything else all sodding day.

Graphs are already in a separate tab *sigh* I think I'm going to go with PFB's idea of a blank template. Will play around & see if that helps although at the mo I'm not optimistic about anything Excel related!
 
Blank templates are always a good idea...I have a file called masters that has blank copies of everything....just in case someone deletes them and the back ups fail :smile:

Sorry by graphs in a seperate sheet I meant a totally diff spreadsheet/workbook....not just tab....I need to work on my english, nightmare when it comes to writing the commentary to go with the bit I'm good at :giggle:
 
first initial thoughts were not enough memory on your pc... If you have little memory and a lot of tabs open (ie excel, outlook, the net, word etc) it will have a knock on effect on anything you are doing.

To check memory usage do the following start bar, open the computer tab , right click on on the C drive, click properties and the available space will be there. If your machine is a bit more up to date then it should show you free space once you have clicked the computer tab..

If you have little memory then delete documents that you have no longer need for (esp piccies as they take a lot of room)
 
CFP it's not memory as the spreadsheet is not stored on my C drive, it's on a shared H drive that's used by a dept - the capacity is huge so shouldn't be the cause (although what the frig do I know! Manager is going to have a look at is as, typical, bloke he reckons he can solve everything).
 
CFP it's not memory as the spreadsheet is not stored on my C drive, it's on a shared H drive that's used by a dept - the capacity is huge so shouldn't be the cause (although what the frig do I know! Manager is going to have a look at is as, typical, bloke he reckons he can solve everything).

but if your own PC doesn't have enough memory on it then it will still have trouble no matter where it is saved too.
 
first initial thoughts were not enough memory on your pc... If you have little memory and a lot of tabs open (ie excel, outlook, the net, word etc) it will have a knock on effect on anything you are doing.

To check memory usage do the following start bar, open the computer tab , right click on on the C drive, click properties and the available space will be there. If your machine is a bit more up to date then it should show you free space once you have clicked the computer tab..

If you have little memory then delete documents that you have no longer need for (esp piccies as they take a lot of room)

This is disk space not memory although the pagefile can be used as memory by the PC and it does use diskspace. So yes it is important to have a few gigabytes of space free on your own PC hard drive for swapping things in and out of actual memory.

To see your PC's performance in windows, click on START then RUN -- in the box type TASKMGR then click OK and it will open the windows task manager.

Click on the performance tab to see your memory and CPU usage.

The processes tab is also good to look at. Find the program using the most CPU and memory and this might point to the culprit slowing your PC to a crawl. A lot of times it might be your anit-virus. Don't start ending processes though, not a good idea.
 
This is disk space not memory although the pagefile can be used as memory by the PC and it does use diskspace. So yes it is important to have a few gigabytes of space free on your own PC hard drive for swapping things in and out of actual memory.

To see your PC's performance in windows, click on START then RUN -- in the box type TASKMGR then click OK and it will open the windows task manager.

Click on the performance tab to see your memory and CPU usage.

The processes tab is also good to look at. Find the program using the most CPU and memory and this might point to the culprit slowing your PC to a crawl. A lot of times it might be your anit-virus. Don't start ending processes though, not a good idea.


@ told :o:o:o:o :smile::smile:
 
My PC works fine doing everything else - is it will worth checking this out?

Yes, having enough disk space is important. Having the task manager open when you run excel will show you what is hogging the system resources.


candyflosspot
no :redface: you were bang on to check the disk space.
 
Have opened the spreadsheet from hell & the task manager. The thing using the most in the 'mem usage' column is Excel around 95,000K & vulscan around 75,000K..... does that mean anything to anyone? There are a few others that are quite high as well but those are the biggest (and keep fluctuating)
 
newrider.com