Scatter chart won't update

[Boyen]

Hello,

I'm using excel 2007

I got a problem with my excel chart. The chart is referring to a some cells that do update, but the chart doesn't.

- I have calculation set to automatic
- There's no "calculating" in the bottom right corner
- I have recreated the chart several times
- It used to work =/

I've googled some and I've seen some references to VB code but I'm not quite sure how to implement those, for instance: http://stackoverflow.com/questions/4...rt-wont-update

Only when I ctrl-x, ctrl-v the chart it updates.

Thanks in advance!

[teylyn]

Hello,

can you replace any confidential data (i.e. text labels, etc) with dummy text and post the file?

cheers,

[Boyen]

Oh sorry, file is too large... I'll see if I can cut some.

EDIT: As I was deleting text it suddenly started working again, I'll update this post if it happens again, thanks!