Hello, I am in an office setting and have created a spreasheet that was working fine until today. When I changed the values in the columns previously the formulas in the spreadsheet would change their calculations based on the new value as soon as I changed it an hit enter. Now the only way it updates is if I hit the change button, or the F9 button. I dont know what I changed that caused it to start doing this, but I need to fix it so it updates immediately after the value is changed and I move away from the cell.
If anyone can shed some light on this I would really appreciate it, I have to turn this sheet in to the boss and now it doesnt work properly.
T
Bookmarks