Hi guys
I have created a workbook composed of many sheets that have charts..Each chart is populated thanks to dynamic ranges ("named range"). I download the data from Bloomberg, do some basic calculations on these time series and plug them into some charts, and update them every day with the new daily numbers..Charts are working well and update as expected, as long I have the data.
But sometimes given the amount of data I am importing, there is a bit of delay, returning some #N/A errors in my times series (once data are downloaded correctly, #N/A disappears, calculation are being performed and it's perfectly fine).
Some of my charts are therefore not updated and I have a VERY annoying pop up "A formula in this worksheet contains one or more Invalid references. Verify your formula contain a valid path, etc etc.."
Once the data are finally fully updated, times series are ok and charts are updating with no issue.
I tried to come up with small vba code to get rid of the alerts but it does not work (msg box is working well)
Private Sub Workbook_Open()
Application.DisplayAlerts = False
MsgBox "Invalid Reference pop up disabled!"
End Sub
Has anyone come up with a proper solution to get rid of the pop up ? Charts are working fine once I have the data so my formulas are fine.
Many thanks for your help
I have created a workbook composed of many sheets that have charts..Each chart is populated thanks to dynamic ranges ("named range"). I download the data from Bloomberg, do some basic calculations on these time series and plug them into some charts, and update them every day with the new daily numbers..Charts are working well and update as expected, as long I have the data.
But sometimes given the amount of data I am importing, there is a bit of delay, returning some #N/A errors in my times series (once data are downloaded correctly, #N/A disappears, calculation are being performed and it's perfectly fine).
Some of my charts are therefore not updated and I have a VERY annoying pop up "A formula in this worksheet contains one or more Invalid references. Verify your formula contain a valid path, etc etc.."
Once the data are finally fully updated, times series are ok and charts are updating with no issue.
I tried to come up with small vba code to get rid of the alerts but it does not work (msg box is working well)
Private Sub Workbook_Open()
Application.DisplayAlerts = False
MsgBox "Invalid Reference pop up disabled!"
End Sub
Has anyone come up with a proper solution to get rid of the pop up ? Charts are working fine once I have the data so my formulas are fine.
Many thanks for your help