0 Replies Latest reply: Nov 12, 2009 4:23 PM by Amirali Vastani RSS

    Can you append data to an existing excel worksheet from QV?

    Amirali Vastani

      Here's my goal:

      1. Extract data from a excel worksheet into QV - (doable)

      2. Do transformations (doable) and then append data to the same excel worksheet (trouble- can delete worksheet and insert)

      3. Refresh Pivot Tables in excel (never done this before in macro)