I want to send a copy of an excel spreadsheet via email

Hi Tom Koch, 

Welcome To Microsoft Q&A Forum! 

Have a good day and I hope you're doing well! 

I tried to reproduce your situation in a test environment, and I completely understand how confusing it feels when a simple “Send via Email” action suddenly stops working especially when you’ve relied on it for ages. 

After some hands-on testing, I discovered a few key insights that might help you get the feature working again. When you choose File > Share > Send a Workbook via Email in Excel for Mac, Excel now expects the workbook to be saved to the cloud first (such as OneDrive or SharePoint).

Here’s what you can do: 

Save the workbook to OneDrive or SharePoint. 

1. You can do this directly from Excel by selecting File > Save As > Online Locations > OneDrive. 

2. Wait until it finishes uploading (you’ll see a small cloud icon or “Saving...” status). 

3. Once the workbook is safely stored online, go to:  File > Share > Share... > Send a Copy 

4. Under the “Send a Copy” options, you should now see Outlook as an available method.  

5. Click Outlook, and Excel will open a new message window in Outlook with your file ready to send as an attachment. 

This updated workflow is designed around cloud storage, so the behavior differs a bit from earlier versions where Excel would attach a local copy right away. 

I hope these steps are at least partially helpful or at the very least, help clarify what’s happening behind the scenes and why the feature seems different now. Hope this clears things up and helps you get your workflow back on track! If you have any concerns or questions, or if I’ve misunderstood or explained anything unclearly, please feel free to reach out anytime. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.