Problems with charts and formulas

Problems with charts and formulas

Hi,

I have a sheet embedded in my website, as can be seen on the following link http://www.planfinan.com/home/planificacion-financiera-acp/modelo, all thoughts about work correctly and make any changes to the first sheet "data" the other results are updated with new values. Also the graphics values are updated, you can check to see the values of the graphs of the sheet "Rtdo_2".
But the problem appears when we move from sheet to sheet in order to display other values. When we return to the graphics, it has the original values, not those that have been modified.

I would appreciate your help. Since I have spent many hours implementing the entire model, it would be a shame that this problem did not obtain desired results.

Beside this, another bug I observe that happen, working after a while with the sheet. It allows you to access and modify the contents of the cells that contain formulas.

Is there any way to get the “answer to the changings” go faster?

I think one of the origins of the problem is in the cell formats, because I think it does not correctly interpret the thousands. You can test that if a sum of a column is quickly changing values, the formula just collapsing and not responding

Thanks and best regards.