Removing Links from Copied Worksheet

[stumped]

I have a contract on worksheet A that has some links that are filled in from another sheet. I need to be able to export the contract to a new workbook, but when I do, it keeps the links. How do I export the sheet to a new workbook and remove the links, yet still keep the data that was supposed to be there?

 

[s-o-s]

On 2002-05-08 15:07, stumped wrote:
I have a contract on worksheet A that has some links that are filled in from another sheet. I need to be able to export the contract to a new workbook, but when I do, it keeps the links. How do I export the sheet to a new workbook and remove the links, yet still keep the data that was supposed to be there?

If your not fussed about maintaining the formulas, the easiest way is to Copy the entire sheet (Ctrl A) and paste special values into a new sheet. If you then do a second paste special formats you will keep all the formatting as well.

 

[stumped]

That worked! Thanks. The only thing with copying you lose your page break formats, etc., but I can work through that. Appreciate the help!

 

[s-o-s]

On 2002-05-08 15:16, stumped wrote:
That worked! Thanks. The only thing with copying you lose your page break formats, etc., but I can work through that. Appreciate the help!

There's a fix on that too,

1 Copy the whole Tab to a new sheet.
2 Copy the sheet (Ctrl A)
3 Paste Values over the top
(You don't need to paste formats now)



_________________<A HREF= "http://website.lineone.net/~s-o-s/Index.html">

This message was edited by s-o-s on 2002-05-08 15:20

 

[stumped]

Awesome!! Thanks a million.