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

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

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