see response to your other posting

--
Regards
Roger Govier



"garwil" wrote in message
...
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