Extract a worksheet from Excel retaining data values not references

I have a workbook that contains about a dozen sheets. One sheet is called "Summary", and most of the data in it is either a reference to another sheet ( ='Pre-Survey'!C10 ) or a label ( =ShipName ).

My client wants me to email him just the Summary page as a one sheet Excel workbook. If I use 'Move or Copy a Sheet' to make a copy of the sheet as a new book, the cells still have references in them ( =("path1234-Titanic.xlsx"!ShipName) ), whereas I want it to simply contain "Titanic".

How do I make the new sheet with the data being fixed at the value from the full workbook so I can email it to someone else and they don't get a bunch 0f ='REF'! errors?

I tried using 'break links', but it didn't help.

Richard

Recent Questions...