The excel file used for the pivot table is saved in a temporary folder on the Blackbaud Hosting Services application server. 

To save the file to the Files Folder or a local drive:
  1. Press the Office Button in the top left corner of the Microsoft Excel window Picture of the Office Button
  2. Select Save As.
  3. You will receive a Restrictions warning message.  Click OK.
  4. Select the location where you would like to save the file. 
  5. Click Save