Cells not updating unless I close sheet and reopen.
I haven't had this problem until today. For some reason, I type =(5*P35)*.01 in a cell and it doesn't convert to the value, unless I close the sheet and reopen. I then set the format to %, and have to again close and reopen sheet. It was working fine yesterday, :(