• 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

    • dBpoweramp Music Converter 2025-06-05 by Razvan Serea Audio conversion perfected, effortlessly convert between formats. dBpoweramp contains a multitude of audio tools in one: CD Ripper, Music Converter, Batch Converter, ID Tag Editor and Windows audio shell enhancements. Preloaded with essential codecs (mp3, wave, FLAC, m4a, Apple Lossless, AIFF), additional codecs can be installed from [Codec Central], as well as Utility Codecs which perform actions on audio files. After 21 days the trial will end, reverting to dBpoweramp Free edition (learn the difference between Reference and dBpoweramp Free, here). dBpoweramp is compatible with Windows 10, 8, 7, Vista, both 32 and 64 bit. dBpoweramp Music Converter features: Convert audio files with elegant simplicity. mp3, mp4, m4a (iTunes / iPod), Windows Media Audio (WMA), Ogg Vorbis, AAC, Monkeys Audio, FLAC, Apple Lossless (ALAC) to name a few! Multi CPU Encoding Support Rip digitally record audio CDs (with CD Ripper) Batch Convert large numbers of files with 1 click Windows Integration popup info tips, audio properties, columns, edit ID-Tags DSP Effects such as Volume Normalize, or Graphic EQ [Power Pack Option] Command Line Encoding: invoke the encoder from the command line DSP Effects - process the audio with Volume Normalize, or Sample / Bit Rate Conversion, with over 30 effects dBpoweramp is a fully featured mp3 Converter dBpoweramp integrates into Windows Explorer, an mp3 converter that is as simple as right clicking on the source file >> Convert To. Popup info tips, Edit ID-Tags are all provided. dBpoweramp Music Converter 2025.06.05 changelog: Darkmode added Core Converter Debug log dumps ID Tags written VST Effect Folders dialog fixed missing InitCommonControls would not show correctly FLAC/Ogg/Opus/etc - allows editing of CDTOC ID Tag CD Ripper secure ripping log where shows TOC was not showing CD Extra correctly CD Ripper was incorrectly setting data track length on main display (for certain drives) CD Ripper internally better handling of corrupt TOCs CD TOC to Tag was incorrectly adding 150 to CD Extra disc CD Ripper shows "AccurateRip Unconfigured" in rip status rather than "not in accuraterip" if unconfigured CD Ripper art paste accepts https CueSheet added as standard - log file written to same folder as cue and folder.jpg AIFF internal code merge (macos >> windows) Download: dBpoweramp Music Converter R2025.06.05 | 82.2 MB (Shareware) View: dBpowerAMP Music Converter Website | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • Staged. It's a requirement that vehicles are strapped down to the bed. Usually wheel and/or chassis tie downs are used. That appears to just be on the winch.
    • I feel Apple's big problem is the lack of big data to train any AI LLM model. They have statistics on usage, but they don't have the written social media, messaging (they were early adopters of end-to-end encryption), they didn't scrape the Internet before the book companies and new sources were wise. So they have no choice but to use a third party LLM provider. Which ties them in knots with their own stance on security and privacy. In short, they are royally stuffed when it comes to developing an in-house AI.
    • Nothing is black and white. Democracy can suck, just as communism can. The risk is people who blindly think one is vastly superior over the other. Democracy needs a lot to make it work well, and there are many examples around the world of it. Good education, mandatory voting, accessible voting, and removing money from politics are just a few elements that need to be sorted for a functional democracy. The USA is the playbook on what not to do with democracy.
  • Recent Achievements

    • First Post
      Mr bot earned a badge
      First Post
    • First Post
      Bkl211 earned a badge
      First Post
    • One Year In
      Mido gaber earned a badge
      One Year In
    • One Year In
      Vladimir Migunov earned a badge
      One Year In
    • Week One Done
      daelos earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      494
    2. 2
      snowy owl
      255
    3. 3
      +FloatingFatMan
      252
    4. 4
      ATLien_0
      225
    5. 5
      +Edouard
      187
  • Tell a friend

    Love Neowin? Tell a friend!