I am using Office 2007 and want to copy a worksheet in an Excel workbook
that contains formats, values, and formulas - I want to copy everything
intact EXCEPT for the formulas. I have tried Copy and Paste Special but that
either doesn't keep the format of the page or I get the format but no
values. What on earth am I doing wrong - I'm sure I used to just do a Copy
and Paste Special and it worked but something somewhere has changed.

Help appreciated

Nick