Hi, i have very limited knowledge of Excel. I've read through a few posts and cant fix this problem. My graph is all wrong.
If i scroll all the way right on the bets tab i have a few #REF! where the dates should be and have no clue how to fix it.
Hi, i have very limited knowledge of Excel. I've read through a few posts and cant fix this problem. My graph is all wrong.
If i scroll all the way right on the bets tab i have a few #REF! where the dates should be and have no clue how to fix it.
Hi msr49,
My guess is that some rows have been deleted from the Bets worksheet. This can throw off background calculations.
It may be possible to tweak the working cell calculations to fix the issue, but my recommendation is to paste your data into a fresh copy of the spreadsheet. If that doesn't fix the issue, send me a PM and I'll give you an email address that you can send a copy of your spreadsheet to.
Thanks.
I think i tried to copy the date column to save typing in the date each time after a huge betting day Saturday and Sunday.
Do you think that's what caused it?
Copying and pasting date values shouldn't cause any problems. I do it all the time, but I guess it depends on how you did it. Issues most often arise due to rows being deleted.
Bookmarks