How can Excel communicate with a remote SQL Server that is disconnected from the Internet?
We have created an Excel Add-In for updating tables from Excel to SQL Server. The Add-In supports working in offline mode, and I'm pretty sure the off-line mode will handle this case.

You will need to install Excel and the SQL Spreads Add-In on both the non-internet connected server and on the laptop. The process will then be like this:


On your "off-line" server containing your SQL Server databases, create a new Excel file and select the SQL Server table(s) you like to update.
The data from the tables will be loaded into the Excel file. When you save the file, all the SQL Server data will be stored into the Excel file. 
Move the Excel file to your laptop and edit the data there. When you save the 
file, all your changes will be stored into the file.  
Move the Excel file back to the server, open the file and click Save in the SQL
Spreads tab in Excel to push the updates to the SQL Server tables.


The Add-In can also check for conflicts if the data has been changed in the database while you were editing it in your off-line doc. 

If that's of interest, you can read more here and download a free trial. 

Disclaimer: I'm the founder of the company.