I have an excel workbook with many sheets, each sheet has a raw data query (live data) of values that are continuously updating at 1 minute intervals per a day.

For each sheet of raw data values I have a dynamic charts that are also updating as the raw data query update/changes.

The problem that I am having is that the charts are not updating as fast as the raw data query that it is linked to is.

Some charts are as much as 3 - 4 minutes behind again not updating at the same time as the raw data query is.

I have done a lot of research, so many hours on this and have tried so many suggestions but I just can not get this to work.

The vb code that I found below works great for the raw data queries but again the charts are not updating at the same time.

Sub RefreshlinksEveryMinute()

Dim dtTargetTime As Date

Debug.Print "Started"

Do While Range("A1").Value <> "STOP"
Application.Calculate
dtTargetTime = Now + TimeValue("0:01:00")
Do While Now < dtTargetTime
DoEvents
Loop
Debug.Print Now
Loop

Debug.Print "Stopped"

End Sub

Any ideas / suggestions would be greatly appreciate. I am at my wits end.

My data queries are not done as pivot tables.

Also Is there some way that I can force the charts to update at the same time that the data query is?