Getting MDX from Excel pivot tables

1. Data: Connections
2. Properties
3. Select Definition Tab
4. Add Log File=c:\temp\pivotlog.txt;
5. OK
6. Close
7. Refresh Pivot

Note: the definition text provided above is case sensitive! Particularly Log File