Audit Arrows/Dots are Missing in Excel 2003!

T

Trevor G

Has anyone had this error in Excel 2003?

I have a formula in A1 that simply adds a number of cells below:
e.g. A1= A2+A30+A350+A1000+A2050

If I click the PRECENDENTS button on the audit toolbar and scroll down to
see which cells it refers to, the arrow shows up OK, but the "dot" that
appears on the cell is not there for the cells furthest away from A1.

This makes it very difficult to audit because without the dot, u can't tell
what cells the formula is refering to.

This was never a problem in version <2003.

Please HELP!

please reply to (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel 07, i don't want circular reference arrows every time I open 1
excel formula auditing arrows not visible 0
Excel 2003 horizontal scroll fails, arrows disappear 1
Dots on Trace Precedents Arrows 1
Unable to activate Trace Precedents or Dependents in Excel 2003 5
Spurious Formula Omits Adjacent Cells 2
Excel 2003 macro from Excel 2000 doesn't work 5
Referring to a range that has been copied (Excel-VBA) 4

Top