Hi,

I have a spreadsheet that looks up data from another worksheet.

I want to be able to see what values have changed when the sheet gets updated when I open it.

I know in excel I can use the TRACK CHANGES function, but this only tracks changes to values that you input manually yourself, such a data or formulas.

It wont track changes of formula results.

Is there any way of doing this? I currently have a sheet with 500 cells, and when the formulas update, I dont know what has changed from the previous save, as there is too much data?

Can anyone help

Marc