Excel Data Connection to SQL Server using Windows Auth from untrusted machine
Our solution ended up being ShellRunas.

https://technet.microsoft.com/en-us/sysinternals/cc300361.aspx

By creating custom shortcuts to launch Excel using the /netonly switch, we can have them enter their domain credentials and then open the needed spreadsheets.  It's not 100% transparent, but it's good enough.