How to hide a coloum in straight table or pivot table but show it in excel dump?

[#1]

Dear Friends

I have to limit the table display.

I can hide some coloum which are not that important.

But I have to show all coloum when an excel dump is taken of that table.

Any suggestions.

Best Regards

Rahul

[#2]

Hi

You can write macro for this