Dynamic data, static range, not updating.
 

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

Dynamic data, static range, not updating.
 

try putting =now() somewhere on the sheet

--
Don Guillett
SalesAid Software

"Mike K" wrote in message
...
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

Dynamic data, static range, not updating.
 

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

Mike

"Don Guillett" wrote:

try putting =now() somewhere on the sheet

--
Don Guillett
SalesAid Software

"Mike K" wrote in message
...
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