• 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

    • I always turn encryption off 1st boot, crazy its on by default on new computers, it should ASK you ON or OFF on 1st boot,, So many people dont even know its on , then forget their windows login and microsoft account,, RETarDED Microsoft is now, , i also find having it on slows things down too
    • Adding AI is just an excuse to hike prices. I don't want any AI features in our Slack workspace and yet will have to pay for it.
    • Hello Could you be kind too help me fix this 3.1gig and not 256gig it says 3.1gig only .someone told me to fix it with this https://www.disk-partition.com/articles/64gb-flash-drive-only-showing-32gb-5740i.html yes my sandisk ultra usb 3.0 256gb wont show up in full .  but i don't know want options i have to use on there can someone  please guide me with step by step instructions please  guide me with step by step instructions on how to repair this .sorry for asking but I've tried but i don't know want i have to do on that programme please help me i am on windows 11 home thank you nick
    • AI is as big a scam as FTX was...run by the same 'group' of people as well.
    • Slack Business+ plan jumps to $15/month as AI features launch by Paul Hill Salesforce has announced a price increase for one of its plans, which will add a few dollars per user each month to organizations' bills. The Slack Business+ plan will see prices rise from $12.50 to $15 per user per month if you pay for a whole year up front; if you pay monthly, the bill will increase from $15 to $18. Salesforce has kept the prices of its Pro plan the same and introduced a new Enterprise+ plan with custom prices for larger organizations. The new price adjustments will take effect on August 17 if you’re planning to renew, and immediately for any new customers. So, if you are renewing before August 17, you will be able to delay this price rise for around a year. The company isn’t just pulling a fast one on customers with these price rises. It’s adding AI to all paid plans, so if you use these features, the increase somewhat justifies them. We saw a similar tactic from Google Workspace back in January. New AI features and deeper Salesforce integration Slack has outlined all the new AI features coming to its Pro, Business+, and Enterprise+ plans starting from July 17. The Pro Plan will have access to conversation and thread summaries, plus huddle notes, while Business+ will have all of those plus: AI Search, Recaps, Translations, File summaries, Workflow generation, and Summarize channels workflow step. The Enterprise+ subscription has all those AI features plus Enterprise search. Additionally, it provides enhanced security, admin controls, governance, and compliance. The company also announced that all plans, including the free plan, will get access to Salesforce Channels, which lets you use Slack and Salesforce together directly within their Customer 360 Apps. Who benefits? By embedding AI right within Slack, organizations should be able to boost efficiency more easily in their daily operations. To ensure that it keeps up with the competition, the company is investing significant resources into its research and development to deliver new innovations. Affected organizations will need to try to find effective ways to use these AI tools to make the price increase worth it, whether this is speeding up tasks to free workers up for other work or something else. The move definitely doesn’t hurt Slack because it’ll make more money whether you use these AI tools or not.
  • Recent Achievements

    • Week One Done
      vivetool earned a badge
      Week One Done
    • Reacting Well
      pnajbar earned a badge
      Reacting Well
    • Week One Done
      TBithoney earned a badge
      Week One Done
    • First Post
      xuxlix earned a badge
      First Post
    • First Post
      Tomek Święcicki earned a badge
      First Post
  • Popular Contributors

    1. 1
      +primortal
      673
    2. 2
      ATLien_0
      288
    3. 3
      Michael Scrip
      223
    4. 4
      +FloatingFatMan
      195
    5. 5
      Steven P.
      144
  • Tell a friend

    Love Neowin? Tell a friend!