Checking formula type (reference to other worksheet or not)

T

topola

In the worksheet cells I have two types of formulas: references to
another worksheet or summing cells within this worksheet.

Is there a formula to tell those two apart?

TIA, topola
 
D

DtTall

In the worksheet cells I have two types of formulas: references to
another worksheet or summing cells within this worksheet.

Is there a formula to tell those two apart?

TIA, topola
Click to expand...

Just look in the formula bar. If it is just a simple sum, that will
be all you see. If it is another workshet, then it will have that
worksheet name in the formula. If it is another file, it will contain
the file path.
 
Top