MASSIVE FILE - chart won't update

Hi

(wasn't getting any responses in the chart section)

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?

A few quick questions...

1) Is the workbook shared, allowing multiple users access at any given time?

2) Is the data in external workbooks, or is everything contained in one workbook?

3) Are you using a pivot table to store your data?

answers.
not shared.
all data in one workbook.
no pivottables.

There is a "dump" sheet where you would paste info from a csv file (out of an accounting system).
everything else is formula driven. There are about 25 pages of info (dept income statements and balance sheets).
The formulas use vlookups back to the main "dump" sheet.
There are some hidden sheets but these don't form part of the graph input.

Basically the idea is that the user just pastes a "dump" and the pack will calculate all the numbers, ratios, etc.

anybody, pleez

almost a year later i'd still like to find a solution to this if anybody has one