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