Excel help- Trace Precedents

onlyoneme

Hi All

Ever since I got my new PC, I can't see the arrows when I select trace precedents (in tools, audit formula). I can still see it if I open the same file in the old PC. It it's definitley relates to the PC.

It's really giving me trouble as I have to audit a lot of data and check formulas.

Any one have any idea how to solve this please.

I would really appreciate it.
Thanks vary much

miketebb

Do you mean that the trace precedents option is greyed-out?

If so, you need to select Tools, Options, View then select 'show all' objects.

onlyoneme

miketebb wrote:

Do you mean that the trace precedents option is greyed-out?

If so, you need to select Tools, Options, View then select 'show all' objects.

No it's not greyed-out. I can select it, but nothing happens. I can't see any arrows at all.

PLEASE SOMEOE HELP ME!!

Chippy_Minton

Try Help - Detect and Repair.

If no joy, copy and paste to a new workbook.

onlyoneme

Chippy_Minton wrote:

Try Help - Detect and Repair.

If no joy, copy and paste to a new workbook.

It doesn't just happen on one spreadsheet - its on all files. So not sure copy and paste on new workbook would help though.

onlyoneme

Chippy_Minton wrote:

Try Help - Detect and Repair.

If no joy, copy and paste to a new workbook.

Tried Detect & repair - still no joy!

Fairwinds

Try going to tools-> options then view tab
and then making sure that the"show all" option is checked under "Objects"

onlyoneme

GordonD wrote:

Try going to tools-> options then view tab
and then making sure that the"show all" option is checked under "Objects"

I've checdked it and this was already ticked .

Do you think there is a problem with the MS office and reinstalling might be the only option?