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

try putting =now() somewhere on the sheet

--
Don Guillett
SalesAid Software
[email protected]
"Mike K" <[email protected]> wrote in message
news:[email protected]...
> 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
> [email protected]
> "Mike K" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>