Hi,
I am creating a standard excel spreadsheet to display a lot of data.
The process flow is:
1) A large quantity of data is copied into a worksheet into pre-named
ranges using VBA.
2) There are additional worksheet tabs with multiple graphs that are
setup to graph the named ranges. Once the data is copied into the
workbook, the graphs update.
3) Additionally, there is a userform on the graph worksheets that
allows users to include and exclude data from charts. I use VBA code
to show or hide ranges on the data worksheet and in most cases the
graphs are updated.
The basic code flow:
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual 'Turn calcs back on
Range("PCL0").Rows.Hidden = False ‘ or true
Application.Calculation = xlCalculationAutomatic 'Turn calcs back on
Application.ScreenUpdating = true

4) The code works as expected to a point. All my XY scatter chars
update normally, however, today I added a bunch of line charts that
are plotted by row in non-contiguous ranges. There are 9 of these line
charts with 250 series each and none update.
5) The workbook has over a thousand named ranges and more than fifty
charts.

What I have done:
Checked Tools-options-chart – checked show visible cells only option
Checked Tools-options-Iterations =10000
Used VBA to: Application.CalculateFull
Used VBA to force a rebuild
Exported all modules and re-imported all text files.

Any other suggestions?