The Excel Price Feed Add-in can probably help you. It provides live prices (from Yahoo Finance) via Excel formulas. I'm afraid you are always going to be limited somewhat by Excel. I have built sheets with 100s of stocks for a watchlist and it performs well, however once you get into the 1000s with several data fields things can really slow down due to the "single threaded" nature of Excel. Good luck!