Could you have both excels connect directly to the datafeed (or perhaps it only lets one computer connect to the feed at a time)?
you wont get around this without programming. What you need to do is to have a centralized place (via API preferably) that captures data. You then stream the data to an RTD server (yes, google it please if you dont know what it is). You can then access the rtd server from within Excel from any machine on the internet that you like. You can actually have the data streamed to as many machines as you like (well there are some constraints but it certainly handles 2 machines ;-) I do not see another around it. Well, a quick and dirty solution (yes dirty!!!) is to capture the incoming data on one machine's Excel spread sheet via VBA events, then write the data to a file (spreadsheet format/text/csv/whatever, but file must be shared by other machine), and on the other machine you periodically read the file to update the data. But again, that is very dirty and I do not recommend it.
Cool thanks for that suggestion. I was leaning towards some mysql type of solution, where i get a mysql server and upload to the server and then have the data stream to the other computer
You can do that, or even simpler, stream it to a messaging bus or in-memory database, something that can be accessed from the outside as well. I highly recommend Redis for that (http://redis.io/). But not sure whether anyone has done work with it in VBA space. Good luck.