PDA

View Full Version : XL query



B.M.
03-12-2007, 07:09 AM
Iím currently playing with a XL 2002 spreadsheet and there are dozens of little green triangles in the top left-hand corner of many of the cells.

They seem to jump around a lot from cell to cell but Iíve no idea what the devil theyíre trying to tell me.

Anyone help.

XL 2000 doesnít have this facility as far as I know and I'm not familiar with 2002.

CYaBro
03-12-2007, 07:14 AM
I think it is just letting you know that that cell has a different formula to the other cells around it.

If you select a cell with this mark an exclamation should appear to the left of it. You can click on this exclamation and choose to ignore the error if you like.

B.M.
03-12-2007, 07:25 AM
I think it is just letting you know that that cell has a different formula to the other cells around it.

If you select a cell with this mark an exclamation should appear to the left of it. You can click on this exclamation and choose to ignore the error if you like.

Thanks for that.

Yep, the adjacent formula's are different, however they are supposed to be. :thumbs: