Has anyone tried creating a pivot in excel? I keep getting an error executing switchwindowaction when I switch to the window CreatePivotTable (I have already opened the Excel spreadsheet function). Do I need to use the window launch excel function even though I used the open excel function?
Any other thoughts on how to subtotal data using variables? I am trying to subtotal invoice amounts for each invoice number and have multiple invoice rows for each invoice number.