• 0

Excel crashing when pulling data from Web.


Question

Is anyone else having this issue? It just started about a week ago.

I have tried repairing the Office install, re-installing Office, and even doing a complete, clean re-install of my system.

It still crashes at exactly the same point of pulling data. I've also tried pulling from multpile, unrelated websites.

 

System is Windows 10 64-bit Pro.

Office is Personal 360. Tried 32 and 64 Bit.

18 answers to this question

Recommended Posts

  • 0

Anything in event viewer?  Crashing while pulling data is kinda non-descriptive ... did you get an errors message or something (aside from this program is not responding)?  Is it a large data file ... did you given it time?  What if you save it locally and pull it?   

 

I probably will not know the answer ... but if you give more information someone might. :) 

  • 0

Excel just crashes. Seriously, that's it.

It crashes, tries to find a "fix", and then restarts. 

If anyone wants to recreate it, here's a link to a site with Table to check it out:

http://www.footballdb.com/stats/stats.html?lg=NFL&yr=2017&type=reg&mode=P&conf=&limit=all

  • 0

Yep no issues here either :)

 

Windows 7  Enterprise x64

Google Chrome Version 61.0.3163.100 (Official Build) (64-bit)

Microsoft Excel 2010 Professional Plus  

 

Did you try something like paste as just text, may be something to do with the URLs that's messing it up. 

  • 0

Excel also crashes for me, if I try and get that data using the Data -> From Web option.

I can copy-paste the table into a worksheet just fine. I can also use Data -> From Web on other sites (not that I often do) without it crashing.

 

Using Office 365 (with latest updates installed).

  • 0
  On 26/09/2017 at 09:56, dipsylalapo said:

Yep no issues here either :)

 

Windows 7  Enterprise x64

Google Chrome Version 61.0.3163.100 (Official Build) (64-bit)

Microsoft Excel 2010 Professional Plus  

 

Did you try something like paste as just text, may be something to do with the URLs that's messing it up. 

Expand  

I can copy/paste just fine. It's when I use the Data-->From Web function that Excel crashes. Some sites work, but

others do not. Specifically, any of the Football sites I go to like NFL.com and so forth. After reading Vitorio's post,

I think it may have to do with the edition of Office I'm using (360 version).

 

Funny thing is, two weeks ago it was working just fine. Grr...

  • 0
  On 26/09/2017 at 19:08, McCordRm said:

I can copy/paste just fine. It's when I use the Data-->From Web function that Excel crashes. Some sites work, but

others do not. Specifically, any of the Football sites I go to like NFL.com and so forth. After reading Vitorio's post,

I think it may have to do with the edition of Office I'm using (360 version).

 

Funny thing is, two weeks ago it was working just fine. Grr...

Expand  

Ah, I hadn't realised you were using the From Web.

 

Just tried it again and had the same issue, so doesn't look like it's Excel version related.

  • 0

Yep, recreated here with Windows 7 Enterprise and Excel 2010. Funny thing is that it is the moment you direct it to the page rather than clicking the import button. I agree with dipsylalapo, that would make me think that it is something on the website that isn't playing nice with Excel's browser.

  • 0

Crashed for me with this in the event log:

 

Faulting application name: EXCEL.EXE, version: 15.0.4963.1000, time stamp: 0x5992b9cb
Faulting module name: jscript9.dll, version: 11.0.15063.608, time stamp: 0xd739c6e6
Exception code: 0xc0000005
Fault offset: 0x000000000011dfdc
Faulting process ID: 0x1bbc
Faulting application start time: 0x01d337698fab6473
Faulting application path: C:\Program Files\Microsoft Office\Office15\EXCEL.EXE
Faulting module path: C:\Windows\System32\jscript9.dll
Report ID: 866eda43-017b-4522-b5ff-c80018ec4fc0
Faulting package full name: 
Faulting package-relative application ID: 

  • 0
  On 27/09/2017 at 11:54, McCordRm said:

That makes me feel better; it means I'm not screwing something up.

Any idea what could be causing the issue on the site? I have no idea how to decipher

the Event Log data.

Expand  

A quick Google of 0xc0000005 points to an access violation error. 

 

If the data from web extract that you're doing works on one site, but not the other. The site may be blocking Excel from pulling its data. 

 

Edit - Not an expert, just my opinion and amazing Google skils ;)

  • 0
  On 27/09/2017 at 11:54, McCordRm said:

That makes me feel better; it means I'm not screwing something up.

Any idea what could be causing the issue on the site? I have no idea how to decipher

the Event Log data.

Expand  

I believe what it's saying is that the table may have some sort of javascript associated that's causing Excel to not work with it.

This is basically page scraping, and I hate page scraping.  Is there no API for your source?

 

Could you try scraping this: http://niklouch.com/tableStats.php

  • 0

OK, what I'm doing there is grabbing the page from the original source, stripping out EVERYTHING but the table and then presenting it back.  So something else on the page (and I believe JavaScript based) is throwing you off

 

How about now?

  • 0
  On 27/09/2017 at 12:27, McCordRm said:

Well crap. Copy/Paste it is then.

Unless there's a way to make Excel ignore Javascript, or work past the error.

Expand  

Do what I did perhaps?  It's a simple script.

 

<?php
$origHtmlContent = file_get_contents("http://www.footballdb.com/stats/stats.html?lg=NFL&yr=2017&type=reg&mode=P&conf=&limit=all");
$startFind = '<table class="statistics">';
$endFind = '</table>';
print strstr(strstr($origHtmlContent, $startFind), $endFind, true) . $endFind;
?>

 

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Is Samsung teasing a Galaxy Z Fold7 Ultra? An official press release suggests so by Sagar Naresh Bhavsar We are inching closer to the launch of this year's premium foldables from Samsung: the Galaxy Z Fold7 and the Galaxy Z Flip7. Recently, a certification revealed that the affordable Galaxy Z Flip7 FE, could also debut alongside the other two foldables. The device is expected to take on the standard Moto Razr 2025. While we were getting excited about the trio, Samsung has put out a press release to create some hype around the upcoming foldables. Interestingly, the company has put great emphasis on the "Ultra" branding, which it usually uses for its Galaxy S-series phone and previously for Note-series phones. So, does this mean, we are getting a Galaxy Z Fold7 Ultra? Time will only tell. As for the press release, it is titled "Meet the Next Chapter of Ultra" and the first line highlights how Samsung has been listening to fans that have demanded "bigger screens, better cameras and new ways to connect and create." To churn up up the hype, Samsung added, "That’s why Galaxy’s next chapter is to provide an experience that seamlessly blends artistry and engineering to elevate everyday interactions." The GIF inside the press-release reveals what looks like the Galaxy Z Fold7 (or the Galaxy Z Fold7 Ultra, if that exists). Rumors have indicated that this year's Galaxy Z Fold7 is getting taller and wider than last year's model, thanks to a bigger display. The Z Fold7 could also feature a titanium backplate to not only reduce its thickness and make it stronger but to shed some weight as well. The company then directs the attention to its AI features such as voice controls for finding the perfect eatery or shopping place, using powerful AI-powered camera features, and so on. We will get to know more about the devices in the coming weeks. By that time, let us know your thoughts, on whether you would like an Ultra foldable or want Samsung to tweak the existing model and keep the space less-crowded.
    • A couple of friends of mine have been building Gunpla for years and got me interested, so I asked and they recommended this as a fairly good quality, very affordable, starting point. https://www.amazon.co.uk/dp/B0BGN9K1MV It was fun to build, didn't take too long, and helped me decide if I wanted to go further with the hobby, which I did.  Still only got this one built, but that's only due to time availability!
    • I've had an original, a Lite, and an OLED and I have just one question for you.  How big are your hands? I got rid of all three because, simply put, they're sized for kids hands more than anything, especially the Lite.  The Switch 2 is a fair bit larger but I'm not agreeing to Ninty's new EULA for the thing.
    • Where does he say that he'll give 99% to Africa? I agree that he said that he'll give 99% of his wealth, and you quote him saying that the majority will go to Africa. The majority of 99% does not mean all of the 99%. It could mean that he'll give just above half of that.
  • Recent Achievements

    • Week One Done
      portacnb1 earned a badge
      Week One Done
    • One Month Later
      portacnb1 earned a badge
      One Month Later
    • First Post
      m10d earned a badge
      First Post
    • Conversation Starter
      DarkShrunken earned a badge
      Conversation Starter
    • One Month Later
      jrromero17 earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      260
    2. 2
      snowy owl
      158
    3. 3
      +FloatingFatMan
      145
    4. 4
      ATLien_0
      140
    5. 5
      Xenon
      131
  • Tell a friend

    Love Neowin? Tell a friend!