Excel Paste Link not copying format
 

Hi,

I am using Excel 2007 and want to break up a large worksheet into many small
sheets but retain the original data in one sheet. When pasting the coipied
data as a link the copied data is inserted into the new worksheet but sans
the original formating such as currency, number formats, text color etc.
What to do? ))
many thanks

Excel Paste Link not copying format
 

First PasteSpecial Link and then PasteSpecial Format
--
Gary''s Student - gsnu200744


"garwil" wrote:

Hi,

I am using Excel 2007 and want to break up a large worksheet into many small
sheets but retain the original data in one sheet. When pasting the coipied
data as a link the copied data is inserted into the new worksheet but sans
the original formating such as currency, number formats, text color etc.
What to do? ))
many thanks