I'm just illustrating situations where Excel can be a problem with ram usage.When I designed worksheet and if there is a database over thousand of records or permanent in nature, I would not do it on the spreadsheet because it is a ram base product. The chance of error and lost of data was too great. Other than power failure and crash, there is accidental erase and row or column deletion. I used Access as the database bucket and have Excel's GUI and VBA to access it. The database bucket (Access file) is password producted and hidden on the server.
Also if there is a large enough data, break them up into multiple sheets, or even multiple files. VBA can execute any sophisticated command and criteria.
Personally, I've seen instrumentation equipment data dump into excel file formats and they produce tens of thousands of lines of data. They're a pain to deal with. Especially troublesome if you need to plot graphs to find trends.
Not if you're on that sweet 10GbE network.If the worksheet has to access data thru the network, you're limited by the internet/network speed which is far slower than a Pentium base machine.