Dynamic data, static range, not updating.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Oh wise ones,
I have a range that is dynamically updated by a SQL
call. The data is changing every 2 seconds. The routine is populated by a
calulate sheet event. My range never changes, it is alway V4:V23 and the data
is updating and changing in that range, but the associated chart will not
update unless I call a refresh sheet function from a supplied addin or close
and reopen the workbook. Can anyone tell me why it won't refresh the chart
when the data linked to it is refreshing normally?

Mike
 
I have =NOW()+"00:00:00" in C3. I took out the offset but it still behaves
the same.

Mike
 
Back
Top