How do i distinguish between formulas that have been linked from a faile - as opposed to a sheet.

Hiya Ilker

Thank you for attending the course on Monday

There is an easy way to tell if a formula is linked to the sheet or a file, you will need to click on the cell that you are interested in, then go to the view menu and toolbars, then click formula auditing to reveal the auditing toolbar

then click on the trace precedents button you will then see a number of arrows pointing to cells or pointing to a mini excel spreadsheet

the one pointing to cells, is linked to the sheet and the other pointing to a mini sheet will show you its linked to another sheet or file

To find out which is which you will need to double click on the end of the arrow line, then if it a file of a sheet the name will tell you which is which

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Best Regards

Mark East