If you are in 2018.1 there might be a windows update that is causing the error being received when attempting to use option 2.
Another option is to try and make a local copy of any data source that you have then republish them with the workbook.
Another step that could also be taken to troubleshoot is closing the connections one at a time and republishing, or attempting to, after every closure. This will help identify the offending connection and can help us better understand what might be occurring.
I got this error again today, and googled the issue, and ironically it took me back to this post which I had forgotten about.
Patrick: I'm using 2018-1 on Mac OSX High Sierra.