Copy full table Pivot into Excel

[#1]

Hi

We have new computers and our users are using newer versions of Windows and Internet Explorer. Still same QlikView version though.

Now, when we chose "Copy Full Table" on pivot tables and then manually paste the text in to Excel the text is still in "Pivot format" On our old system each row got a value. Is this possible to get again?

Thanks.

[#2]

In the Presentation tab select always fully expanded and then copy full table.. I think i will work..

[#3]

But our users dont have access to the Presentation tab. And we want to keep the table as a Pivot.

[#4]

pls write following macro.

set obj = ActiveDocument.GetSheetObject("CH703")
obj.ExportEx "E:\Qlikview\Department_Loadinng.xls",5

[#5]

Is this to only one Object? We want it to be applied to all tables, and only when the user want to copy the text. I mean, not automatically

[#6]

i dont think there is such property. You have to use macro..

[#7]

Ok, thanks anyway of your help.

Do you know why it worked before? Maybe earlier version of IE Plugin or something?