If your workbook file is on OneDrive or SharePoint - Team Sites, choose Import or Connect. Click add and it prompts for a value, type one in and then press 'Close' and then select 'Return Data to Microsoft Excel' from the 'File' menu. This is the current experience when linking to local files from shared workbooks on both Mac and Windows. You will see that all files and folders details are imported to your worksheet. These tools, based on Power Query technology, enable you to easily connect, combine, and shape data coming from a variety of sources. I appreciate any feedback/solutions/ideas. Get & Transform lets you transform the data from your data sources in ways that help you analyze it. Recover Excel File on Mac with Recoverit. We are working on supporting refresh from HTTP sources but it will take us some time to get there. If you're regularly working with Excel files on Mac, you need to learn how to recover them after Excel crashes, which happen more often than they should.