Ok, I figured it. I went to the spreadsheet and went to each sheet. Some had 71 rows of data, but a little over 1000 total rows. This was pretty consistent along all the sheets. So I went to each one and deleted the majority of the empty rows. They are filled in with an importrange command, so as more is added they will fill in more rows, but for now the execution time went from 30+ sec and timing out, to 11.1 secs.