Hi

i have a 35 meg file with lots of calculations. It is a financial reporting pack.

I've tried inserting a chart as an object in a worksheet, or as a worksheet on it's own. The chart comes up fine and i can specify the source data.

Problem is when there is a change in the source data, then the chart DOES NOT update values automatically as it should.
If i then select the chart, select Source Data, and then simply click OK without changing any of the inputs, the chart will then update to the latest values.
(Calculation is set to automatic)

Any suggestions? Is this normal with such large files?