As i understand his problem he has a file that gets data (
the workbook relies on live feed financial market data
), this data is automatically calculated.
I guess he wonders why the result takes some time to be displayed (afer the input has been made, the dependent cells do not change instantly),but that is normall, espacially if you have something like:
the Function in the cells calls upon other functions within that function to aid with the calculation
.
And now he wonders why he gets such changing, i guess he should look thru all his functions, to make sure, he'S calculating what he really wanted to. And for the #value thing, 1. Choice the value is to large to be shown, so just enlarge the column-width. 2 choice your data-format is wrong