Hello everybody
Is there any other formula instead of OFFSET?
Because Excel prompts to save every time I close it even if I don't change anything.
Here's my formula: G5=OFFSET(G5,-1,0)+F5-E5
And if I use this formula, auto-update won't work in table: G5=G4+F5-E5
http://www.excelforum.com/excel-general/…ave-prompt.html
http://www.mrexcel.com/forum/excel-qu…ave-prompt.html