Copy, paste special - values only. But keep groups on rows!

Dear All,

I am sure this is an easy one, but it was driving my manager crazy and he can't get it to work.

We have a large spreadsheet that is grouped on the rows so we can see summaries of each section

However the sheet is full of OLE's so we need to copy and paste special as values only so it doesn't bring the formulae through too.

However even if we copy the format too it won't keep the groupings at the side only along the top on the columns.

Please can someone help as it is only a simple thing but will save so much time

Thanks

Emmaly