How to autocreat PivotTable in Excel with LabVIEW?

[labc]

Dear all,
   i want to get a report with PivotTable, however i didn't find there is a specific vi for it. So, i record a Macro to do this job, and then, another question appears.
I have to enable Macro "run" in Excel, which is not so convenient for all user.
   Is there a better method?

Labc

[labc]

I upload a Excel table here, how to add the PivotTable in sheet2 automatically?

Labc

[rj_501]

Hi labc

Have found any solution to this?

RJ

[Bob_Schor]

This got no response eight years ago.  Why "hijack" a thread that has been abandoned for that long?  Proper Forum Etiquette (or Polite Behavior) is to start a new Message, specifying as precisely as you can what you are trying to do, and, if appropriate, attaching the LabVIEW Code (= VI) that you are trying to use to accomplish your task.

Bob Schor