Under View - Toolbars, select formula auditing. Now, you can click the "show
precedents" button to have XL trace back. If precedent is in another
workbook, an icon of a table will apear. Double click on icon to bring up the
Go To dialogue. You can then use this to go straight to the cell in the other
workbook. NOTE: Workbook must be open. You can't force XL to open another
workbook via formula auditing.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jill" wrote:

HI, use CTRL [ to find cells that are used in a formula, across sheets and
workbooks. Trying to then get back to original cell but CTRL ] only seems to
work in the same sheet, not across workbooks. Can anyone help please?
--
Jill