Hello!
I had set up a couple spreadsheets at my office...one to keep track of sales/commissions the other is a timesheet. Up until a week or so ago
they were working fine. I would simply open a new tab at the bottom and copy the blank page with my formatting and formulas into it for the next
month. As I enter new sales amounts it would update my totals. Not anymore. Now whenever I enter new info I have to click in the box where my total
should be then click at the end of the formula at the top of the screen and hit enter.
Same with the timesheet. It won't update my hours worked unless I click in the formula bar at the top and hit enter.
Any idea how I can fix this without having to start all over from scratch? I already tried starting a new sheet and copying the formulas over
and I get the same thing. It won't apply the formulas automatically. I'm hoping it is just a setting??
Thank you for any help!!
Bookmarks