I am not sure if this works with xl97 but it certainly works with later
versions.

Right click on one of the worksheet names at the bottom of the screen.
Click on select all sheets.
Select menu item Edit-Find.
Enter the text to find and then click on Find All.
If it works, you should have a list at the bottom of the dialogue box with
the sheets and cell addresses of all occurrences of the text. Click on any
one of them and it will take you to the cell.
You should be able to click on the cell and edit it without loosing the
dialogue box with the list. Note the value changes in the dialog box but you
don't loose the sheet name and cell address.

I will appreciate it if you let me know if this works in xl97.

Regards,

OssieMac

"Chaz" wrote:

I am trying to find a formula in Exel 97 so that I am able to find a text
value on multiple sheets in a workbook and it will return the name of the
sheet for me. I have two spreadsheets open and want to find out what sheet/s
a cell reference is on: example. xyz is on sheet ?? and sheet ?? there are
mutiple sheets which can have that reference on them but for me to go through
them all would take days. Is this possible to do in a formula?