excel crashes when refreshing data from web

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tackleberry
    SBR Sharp
    • 12-01-10
    • 441

    #1
    excel crashes when refreshing data from web
    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.
  • muldoon
    SBR MVP
    • 01-04-10
    • 4397

    #2
    Are you pulling data from websites or through an ODBC connection?
    Comment
    • JVP3122
      SBR MVP
      • 05-02-09
      • 1048

      #3
      It almost might be better to use Python's scrapy package to get info from a website and store it as a .csv.
      Comment
      • Tackleberry
        SBR Sharp
        • 12-01-10
        • 441

        #4
        Originally posted by muldoon
        Are you pulling data from websites or through an ODBC connection?
        websites
        Comment
        • thom321
          SBR High Roller
          • 06-17-11
          • 112

          #5
          Are 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
          • TomG
            SBR Wise Guy
            • 10-29-07
            • 500

            #6
            pretty standard.

            how are the tables organized? are they each on their own tab or on one big worksheet?
            Comment
            • Tackleberry
              SBR Sharp
              • 12-01-10
              • 441

              #7
              one 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
              Working...