I have more of a data handling question. I have a large spreadsheet that I am pulling in data from a server, sometimes for as far back as 1 year, depending on the time increment it could be over 10,000 records per column. I have multiple columns and multiple sheets where this is happening.

My question is am I better off using a spreadsheet just to handle the data acquisition and another one for all the additional calculations, and possibly a third for all the graphs? I guess I am thinking if I break this up more it will be more stable. Thank you for your input.

DK