> I'm guessing, but have you tried Tools | Cell Content > | Recalculate (or
> F9) or Ctrl+Shift+F9 (Recalculate Hard)?
This doesn't help.
A colleague found that that hiding then unhiding the rows that are
below the charts solves the issue. Note that these rows are not the
ones that contain the
It is a real nightmare: I cannot find why sometimes charts
automatically update and sometimes they don't.
In particular, I have a series that sometimes has some points,
sometimes not and very often, when later I add some new values to an
empty series, the chart do not show the new point. That's
Hi Steve,
For my application using the [SS].00 option did the trick. As I required
to determine number of seconds required to move 500m. I also need to
sum up the resultant column.
Thanks for all the help both on-line and off-line.
Vytas
On 3/29/2017 3:20 PM, Steve Edmonds wrote:
Hi.
2
Usually when I'm pasting in time into a cell formatted for time, I'll
paste special. The worst that happens is that the time is affixed with
a single quote mark. Then I find and replace "^." with "&" (no quote
marks).
On 3/29/2017 2:32 PM, Steve Edmonds wrote:
Hi.
Playing with the