Trace Dependents?

C

CLR

Hi All..........

I opened a sheet today from someone else and on several cells which has
seemingly normal two character or one or two digit values, I did a "Trace
Dependents" on and got an ARROW to an apparently blank cell and it pointed
to a small icon of a miniature spreadsheet inside the cell...........the
icon disappeared when I deleted the Trace Dependents arrows..............can
anybody explain this please?

TIA
Vaya con Dios,
Chuck, CABGx3
 
J

Jay

CLR said:
I opened a sheet today from someone else and on several cells which
has seemingly normal two character or one or two digit values, I did a
"Trace Dependents" on and got an ARROW to an apparently blank cell and
it pointed to a small icon of a miniature spreadsheet inside the
cell...........the icon disappeared when I deleted the Trace
Dependents arrows..............can anybody explain this please?

The dependent is on a different sheet.

Double-click on the arrow and a tiny window opens showing the details of
the dependency.
 

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

Top