Thread: 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
dguillett1@austin.rr.com
"Mike K" <MikeK@discussions.microsoft.com> wrote in message
news:A8E4C032-1E33-4788-B2CC-CC235D8813D4@microsoft.com...
> 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
> dguillett1@austin.rr.com
> "Mike K" <MikeK@discussions.microsoft.com> wrote in message
> news:A8E4C032-1E33-4788-B2CC-CC235D8813D4@microsoft.com...
> > 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
>
>
>