Re: Finding errors on excel
Hi Pablo,toggle quoted messageShow quoted text
I've been away, so maybe someone else has answered your query, or it's no longer relevant.
In Excel 2013, you can go to the Formulas tab on the ribbon, and in the formula auditing group, choose error checking. That gives a menu with circular references on it, which has a submenu that lists the cells containing circular references.
If you're not using the virtual ribbons, you can get to this option with Alt, M, K, C.
Hope that helps,
Senior Assistive Technology Assistant
Working from home in Lancaster
T: 0746 871 1921
From: Jfw [mailto:firstname.lastname@example.org] On Behalf Of Pablo Morales via Jfw
Sent: 24 July 2015 01:17
To: 'The Jaws for Windows support list.' <email@example.com>
Cc: Pablo Morales <firstname.lastname@example.org>
Subject: Finding errors on excel
On Excel, is there a way to find formulas with circular reference? I have a excel document with 1257 formulas, and I need to find a formula where is occurring this error "circular reference".
Is a way with jaws to find where is the problem between all these formulas?
-------------- next part --------------
An HTML attachment was scrubbed...
Jfw mailing list
The Guide Dogs for the Blind Association
Registered Office: Hillfields, Burghfield Common, Reading, Berkshire, RG7 3YG. A company limited by
guarantee registered in England and Wales (291646) and a charity registered in England and Wales
(209617) and Scotland (SC038979).
Tel: 0118 9835555