Numbers change when they shouldnt?

Copper Contributor

Hey,

 So I'm having this issue when I'm using Excel. I've table which contains some formula answers, but whenever I press anything like anything at all the answers change? For example, whenever I press save or press on a cell that I haven't referred to at all the answers completely change. They don't round up or get simplified or anything, they just change to a different answer. Anyone know what's up with this?

1 Reply
This sounds like you have a "Volatile" function which is a fancy way of saying a function that always gets recalculated. And in your case it sounds like you have the RAND() function or one of its cousins on the sheet but it could be a UDF (user defined function like a macro). Without looking at the sheet I suggest you start by doing a FIND for "RAND"