Trace dependents/precedents

Hi Jeremy

Thanks for getting in touch.

Once you've turned on Formula Auditing, you may see a dashed black line, indicating an 'external' reference. This means the reference goes off the current sheet.

To view this link, point your mouse at the line and double-click. The Go To dialogue will guide you to it's source.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector