A sign that it's time for me to get a new computer or could it be in how I have my spreadsheet setup? There are about 200 seperate tables I am trying to refresh, however it takes much less to cause excel to crash.
excel crashes when refreshing data from web
Collapse
X
-
TackleberrySBR Sharp
- 12-01-10
- 441
#1excel crashes when refreshing data from webTags: None -
muldoonSBR MVP
- 01-04-10
- 4397
#2Are you pulling data from websites or through an ODBC connection?Comment -
JVP3122SBR MVP
- 05-02-09
- 1048
#3It almost might be better to use Python's scrapy package to get info from a website and store it as a .csv.Comment -
thom321SBR High Roller
- 06-17-11
- 112
#5Are you using any VBA code or do you have 200 live queries that are refreshed e.g. by "Refresh All"? I personally avoid having live queries in my workbooks since it pretty quickly overwhelms Excel, from my experience at least. I sometimes use queries to import the data but only store the data itself and not the query and its associated named range. That approach does require some amount of VBA code.
If you are willing to share the workbook I can take a look and see if I can find a quick fix for it.Comment -
TomGSBR Wise Guy
- 10-29-07
- 500
#6pretty standard.
how are the tables organized? are they each on their own tab or on one big worksheet?Comment -
TackleberrySBR Sharp
- 12-01-10
- 441
#7one big worksheet and no VBA code. I was hoping I could get away with this approach but obviously not. Really just wanted to know it's a normal excel issue and not related to my hardware. Will probably be a bit of a headache for me to figure it all out and get it running smoothly but as with everything doing it on my own will allow me to learn much much more. Thanks all.Comment
SBR Contests
Collapse
Top-Rated US Sportsbooks
Collapse
#1 BetMGM
4.8/5 BetMGM Bonus Code
#2 FanDuel
4.8/5 FanDuel Promo Code
#3 Caesars
4.8/5 Caesars Promo Code
#4 DraftKings
4.7/5 DraftKings Promo Code
#5 Fanatics
#6 bet365
4.7/5 bet365 Bonus Code
#7 Hard Rock
4.1/5 Hard Rock Bet Promo Code
#8 BetRivers
4.1/5 BetRivers Bonus Code