Excel advice needed

Grey

Grey

Senior Jockey
Joined
Jul 4, 2004
Messages
9,484
Location
Dublin
The Excel spreadsheet I use to record my bets is becoming a serious pain in the apse. Any time I try to insert an extra row or copy data, even just a few cells, it takes at least a minute to think about it and sometimes gives up.
 
How big is it? Are there lots of calculations going on? You could try temporarily turning off auto-recalculation in the options to see if that makes a difference (I think you can use F9 to manually re-calc the whole sheet when you need to).
 
It's not enormously complicated; wins and losses are calculated and there's a running total. Everything else is descriptive.

When the sheets get too big I close them off and start a new file. The current one has only about fifty rows.

It sounds daft, but some rows and cells in the sheet seem to be on a go slow more than others.
 
It's not brilliant at times. I'm wondering whether I have enough disk space. Two thirds is taken at present.
 
Are you copying and pasting data in, or always entering it yourself?
Click to expand...

I copy account statements from the bookies' websites as unicode text onto the spreadsheet in order to have it in front of me while I enter the information it contains. This I do manually, although I copy and paste from one row to the next as much as I can. Once the data is entered I delete what I've copied from the websites.
 
If you paste it as unicode no problem - I just wondered whether any html gremlins were getting in.
 
Grey said:
The Excel spreadsheet I use to record my bets is becoming a serious pain in the apse. Any time I try to insert an extra row or copy data, even just a few cells, it takes at least a minute to think about it and sometimes gives up.
Click to expand...

My comments will not be of much use to you, however, I use a work laptop for Excel rather a lot. When not logged in to the network it often has the same difficulty that you mention with spreadsheets that work fine normally.

If that rings a bell, update your records at work!
 
Thanks for the help, guys.

I started a new sheet in which I entered all the formulae on the first row manually and formatted all the cells again from scratch. Nothing has been copied across from earlier versions and now it's all working fine again.

Perhaps the HTML gremlin theory might be the explanation. I normally copied accounts data from bookie websites as unicode text but almost certainly forgot to take that precaution once or twice.
 
Back
Top