How to remove formula pivot sheet and send through mail

To remove a formula pivot sheet and send it through email, you can follow these steps:

Removing the formula pivot sheet:

  1. Go to the worksheet that contains the pivot table.
  2. Select the entire pivot table by pressing Ctrl+A or by dragging your mouse to select the entire table.
  3. Right-click on the selected pivot table and choose "PivotTable Options" from the context menu.
  4. In the "PivotTable Options" dialog box, click on the "Layout & Format" tab.
  5. Uncheck the box next to "Show field buttons" and click "OK".
  6. The formula pivot sheet will now be removed, and you will be left with a regular table.

Sending the pivot table through email:

  1. Select the entire pivot table (or the range of cells that contains the pivot table) by pressing Ctrl+A or by dragging your mouse to select the entire table.
  2. Go to the "File" menu and click on "Save As" to save the pivot table as a CSV file.
  3. In the "Save As" dialog box, select "CSV (Comma delimited)" as the file type and choose a location to save the file.
  4. Click "Save" to save the file.
  5. Open your email client and compose a new email.
  6. Attach the CSV file to the email by clicking on the "Attach file" button and selecting the CSV file you just saved.
  7. Enter the recipient's email address and any other necessary information, such as a subject line and message body.
  8. Click "Send" to send the email.

Alternatively, you can also use the "Export" feature in Excel to send the pivot table through email. To do this:

  1. Select the entire pivot table (or the range of cells that contains the pivot table) by pressing Ctrl+A or by dragging your mouse to select the entire table.
  2. Go to the "Data" menu and click on "Export" to open the "Export" dialog box.
  3. In the "Export" dialog box, select "Email" as the export option.
  4. Enter the recipient's email address and any other necessary information, such as a subject line and message body.
  5. Click "Export" to send the pivot table through email.

Note: Make sure that the recipient has the necessary software to open and view the CSV file.