I did this for a client recently. Essentially you need to make a list of the
names and a list of the refers to and then replace each. Somewhat involved
but the proper macros can do it.

--
Don Guillett
SalesAid Software

"Bharath Rajamani" wrote in
message ...
My spreadsheet has many formulae with Names. I want to view the sheet with
the actual cell references instead of Names .. how to?