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:
- Go to the worksheet that contains the pivot table.
- Select the entire pivot table by pressing
Ctrl+A
or by dragging your mouse to select the entire table. - Right-click on the selected pivot table and choose "PivotTable Options" from the context menu.
- In the "PivotTable Options" dialog box, click on the "Layout & Format" tab.
- Uncheck the box next to "Show field buttons" and click "OK".
- The formula pivot sheet will now be removed, and you will be left with a regular table.
Sending the pivot table through email:
- 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. - Go to the "File" menu and click on "Save As" to save the pivot table as a CSV file.
- In the "Save As" dialog box, select "CSV (Comma delimited)" as the file type and choose a location to save the file.
- Click "Save" to save the file.
- Open your email client and compose a new email.
- Attach the CSV file to the email by clicking on the "Attach file" button and selecting the CSV file you just saved.
- Enter the recipient's email address and any other necessary information, such as a subject line and message body.
- 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:
- 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. - Go to the "Data" menu and click on "Export" to open the "Export" dialog box.
- In the "Export" dialog box, select "Email" as the export option.
- Enter the recipient's email address and any other necessary information, such as a subject line and message body.
- 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.