I have many spreadsheets across several Excel files that contain updated statistics that I now need to update the graphs inside each worksheet. Any shortcuts? I do not want to go back and highlight each required cell and redo each of the charts. I have used the method or opening the Select data range and adding the 'Sheetname'!$A$84:$B$84, method, but even this is too time cosuming. We have here 12 of these Excel applications with 5-6 worksheets in each one and 3 graphs per worksheet. Any help would be great!
Chuck
Chuck