Hello,

I'm working on a workbook that has many formulas spread over 5 or 6
worksheets. In an attempt to tidy things up, I've been trying to
convert a lot of the references to names, using insert | name | apply.
This only seems to works for me if the formula and the reference are on
the same sheet, else I get a message "Microsoft Excel cannot find any
references to replace'. According to what I've read, this should work
regardless if they're on the same sheet or not. Maybe someone can tell
me what I'm doing wrong (using Excel 97)

regards

Dave