Excel crashing when pulling data from Web.

Recommended Posts

McCordRm    415

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.

Share this post


Link to post
Share on other sites
McCordRm    415

Still haven't been able to find a fix for this crap.

Share this post


Link to post
Share on other sites
Jim K    8,914

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. :) 

Share this post


Link to post
Share on other sites
Daedroth    423

I've just copied the data from that table into Excel fine.

 

Windows 10 Education 1607 x64

Google Chrome 61.0.3163.100

Microsoft Excel 2016 Professional Plus  

Share this post


Link to post
Share on other sites
dipsylalapo    875

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. 

Share this post


Link to post
Share on other sites
virtorio    2,177

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).

Share this post


Link to post
Share on other sites
McCordRm    415
9 hours ago, 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. 

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...

Share this post


Link to post
Share on other sites
dipsylalapo    875
11 hours ago, 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...

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.

Share this post


Link to post
Share on other sites
Nick H.    7,970

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.

Share this post


Link to post
Share on other sites
Nefarious Trigger    6,799

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: 

Share this post


Link to post
Share on other sites
McCordRm    415

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.

Share this post


Link to post
Share on other sites
dipsylalapo    875
11 minutes ago, 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.

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 ;)

Share this post


Link to post
Share on other sites
Nefarious Trigger    6,799
4 minutes ago, 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.

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

Share this post


Link to post
Share on other sites
McCordRm    415

Looks like I can pull from that just fine.

Share this post


Link to post
Share on other sites
Nefarious Trigger    6,799

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?

Share this post


Link to post
Share on other sites
McCordRm    415

Well crap. Copy/Paste it is then.

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

Share this post


Link to post
Share on other sites
Nefarious Trigger    6,799
Just now, McCordRm said:

Well crap. Copy/Paste it is then.

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

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;
?>

 

Share this post


Link to post
Share on other sites
McCordRm    415

Kewl, I'll run with that for now.

Hopefully, it gets resolved soon. Like I said, it was working fine a couple weeks ago.

Thanks for the help.

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Recently Browsing   0 members

    No registered users viewing this page.