I have a 8.3mb file saved as 97-2003 with 15 worksheets. 4 of these worksheets contain raw data that populates the others in various ways. One sheet has a number of charts populating from data in that sheet. The same charts are reproduced in another sheet and use the same data source. When I do a refresh (F9) the charts in the sheet that contains the data update but the charts in the other sheet do not alter although the source data is the same.