I get this message three times, and once I am done clicking ok on all three of them, my spreadsheet works just fine. The problem is, I have to send it to a bunch people. I have a sheet with raw data a sheet with pivot tables a sheet with a dashboard and a simple macro

Aug 20, 2015 · Once it does, click Return Data to drop your data right back into your worksheet. And that’s it; your data is now in your Excel workbook, live and ready to use in Excel 2016 for Mac or Excel for Windows! Working with a third-party data provider works the exact same way. Re: vba code to automatically open, refresh all data and save workbook If you took the time to look at the link that mole999 provided, you would see that it is Application.SendKeys in the code. Regards,