CODEWITHSUNDEEP
excelvba
casaler
casaler

Reputation: 41

Dynamic chart produces a pop-up information/error (check cell reference) message when calculation set to automatic

I have a dynamic chart that generates a pop-up warning/error message stating there is a cell reference issue. The message goes away when I change the calculation option from automatic to manual and press F9. I have tried adding Application.Calculation = xlCalculationManual to the beginning of my VBA code but that does not seem to work. I believe the issue stems from the chart comparing 2 sets of data (initial and follow-up) and there is a null in the initial dataset.

Any ideas on how to eliminate the message so my team does not have to manually change from auto calculation to manual and select F9? (I can send the workbook if needed.)

Upvotes: 0

Views: 30

Answers (1)

casaler
casaler

Reputation: 41

I think I figured it out. I had the Application.Calculation = xlCalculationManual statement in the wrong location. I have run the code a few times now and it is not generating the error.

Upvotes: 1

Related Questions