Export pivot table to excel (with sub totals)

[#1]

Hello guys,

I'm trying again and again to export this table (see attachment) to excel with a macro.

It seems that the values are in a mess in the excel file.

* it is Very important that the subtotal also will be export to the excel

any help with this issue will be highly appreciated

Thanx guys![:)]

[Anonymous]

Hi.

Maybe it's a stupid answer, but have you tried to mark the "Export to Excel" option in the tittle?

I've tried and seems that it works.

[#3]

Hmmm...well.......I need that the export to excel will occur via macro

[Anonymous]

Hi, I think the solution is to allow system access.

I've tried with your QV file and it worked.

Regards.

[Anonymous]

Hi avivcoil, did it work for you?

Please answer.

Thks.