I have a workbook that has a lot of formulas that use named ranges.
Is there a way to remove the named ranges and have the formulas show
conventional cell references?

Not sure if there is an option in Excel or this requires a macro? I'm
using XL 03.

Thanks.