Hide fields list in PivotTable

I have an excel (in 2007) connected to a cube, I want to send this sheet to a client who doens't have the cube. This works perfectly. But I also want to hide the fields list so the client doesn't see the fields. Is this possible.

If you just want your client to see the result of your ready made pivot table I would suggest that you copy your sheet, and paste it into another workbook. Use : Paste Special -> Values
If you want preserve the formatting do also : Paste Special -> Formatting

If you want your client to play with your pivot table, I don't think there is any way of removing the field list. If you are afraid that your client can access fields that you don't want them to access you have to remove those field from your query, so they are not included in the pivot cache of your workbook.

Good tip thanks, I tried copying and pasting the values and formatting, however formatting doesn't take over background colors and for example bold font, ... Any way of doing that.

I don't know why you don't get bold and background colors copied too when you use Paste special->formats. This should work.
The only thing that is not copied when I do this is the grey background the field headers gets as default by the pivot table. Usually I will want to do some formatting myself of the result I get from my pivot copy before I send it to a client.

Make sure you copy the whole worksheet. Click on the grey field in the upper left corner of the row and column headers to select the whole sheet. Then copy. And do the same in the destination sheet before you paste the formatting. Then you should get your column widths copied too.