Problem Compressing a Large Pivot Table File

My pivot table file is currently 12.7 MB and I need to get it much smaller so I can email it and it still be functional with the data.

I have tried right clicking on the pivot table, going to PivotTable Options, clicking on the data tab, unchecking the 'save source data with file' box, and checking the 'refresh data when opening file' box. This shrunk the file perfectly but when i email the file the Pivot Table was unusable because there was no data to back up the function.

The Error messages I got were 'Cannot open PivotTable source file'..... and 'Pivot Table report was saved without the underlying data. Use the Refresh Data command to update the report'. When I click on Refresh Data I still get the same error message.

If you know a way I can make this File smaller and still functional please let me know.

Thanks

This is a duplicate post

I have and I get the error message 'Either there is no default mail client or the current mail client cannon fulfill the messageing request. Please run Microsoft Outlook and set it as the default mail client."
Outlook is the default so I dont know why it wont zip?