Hi,
May be obvious but I have noticed in a file I'm working in, if you do a sheet calc (Shift+F9) the check that is built in is zero.
However if you do an F9 calc, i.e. the whole file, a difference appears even though nothing has changed.
My guess is something to do with iterative calculation being turned on because the file has circular references to help link income statement and balance sheet for things like depreciation calculations which rely on each other to calculate.
Not sure if that makes sense as this is a file I have inherited but is this the reason for a disappearing/appearing difference?
Thanks!
May be obvious but I have noticed in a file I'm working in, if you do a sheet calc (Shift+F9) the check that is built in is zero.
However if you do an F9 calc, i.e. the whole file, a difference appears even though nothing has changed.
My guess is something to do with iterative calculation being turned on because the file has circular references to help link income statement and balance sheet for things like depreciation calculations which rely on each other to calculate.
Not sure if that makes sense as this is a file I have inherited but is this the reason for a disappearing/appearing difference?
Thanks!