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

You'd probably be better off using purpose-designed software for analysing the data on the server instead of trying to load it into Excel to analyse there.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

What about a tiny response to the below question you asked on the 13th June 2016?

Auto update excel graph range, ignore data when date reads 00-Month-00

XOR, I apologize I missed that reply, your solution worked perfectly. Thank you for the help!!!

Dan

I know you will do the same for someone else.

If question solved, please indicate as such - Thx ( click " Thread tools" - "mark thread as solved")

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you all for the replies.

I will look into something else.

DK.

I don't see the option under thread tools to mark thread as solved.

DK

Done. As Mod I see it, don't know about users, but I think it should be there.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post