"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years.
I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.
Large file, the data series in the charts are described by named ranges.
I was hoping one of you guys might take pity and help, espeically if you've heard of this before?
I've created a dashboard which should allow a user to specify a time period (data validation), which updates a data table from which 7 graphs read from.
Almost all the time, when I update the data, the charts refresh to reflect this.
However sometimes (randomly) the charts do not update.