• 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

    • Last chance to download DearMob iPhone Manager for PC/Mac (worth $79.95) for free by Steven Parker Claim your complimentary copy worth $79.95 for free today, before the offer ends today on June.3. Download a free licensed copy of DearMob iPhone Manager for effortless backup, restore, and flexible data transfer. Manage videos, photos, music, apps, contacts, ebooks, and 17+ other file types without data erasing risks. Easily transfer, manage, and back up your iPhone or iPad data--safely and without data loss. Free up space and clean unwanted files in just a few clicks. Get your free licensed copy for PC or Mac, fully compatible with all iOS and iPadOS devices. Highlights: Lossless Photo Transfer: Move or albums with zero quality loss; convert HEIC to JPG for easy sharing. Batch Video Export: Transfer videos to your PC without compression, freeing up valuable iPhone space. Custom Music & Ringtones: Add music, playlists, or create ringtones from your favorite songs. One-Click Backup & Restore: Protect your data with fast, reliable backups and restores, plus password encryption Comprehensive Data Management: Manage photos, music, videos, messages, apps, contacts, ebooks, and more. Offline Management: Take full control of your data without needing an internet connection. This free offer ends on 6/3/2025—don’t miss out! How to get it Please ensure you read the terms and conditions to claim this offer. Complete and verifiable information is required in order to receive this free offer. If you have previously made use of these free offers, you will not need to re-register. While supplies last! Free download: DearMob iPhone Manager for PC/Mac (worth $79.95) Offered by Digiarty WinXDVD, view other free resources The below offers are also available for free in exchange for your (work) email: DearMob iPhone Manager for PC/Mac ($79.95 Value) FREE – Expires today 6/3 The Cybersecurity Control Playbook ($100 Value) FREE – Expires 6/4 The Embedded Linux Security Handbook ($31.99 Value) FREE – Expires 6/4 Teach Yourself VISUALLY Microsoft 365, 2nd Edition ($20 Value) FREE – Expires 6/4 Winxvideo AI V3.0 Lifetime License for PC ($69.95 Valued) FREE – Expires 6/8 Aiarty Image Enhancer for PC/Mac ($85 Value) FREE – Expires 6/8 Solutions Architect's Handbook, Third Edition ($42.99 Value) FREE – Expires 6/10 AI and Innovation ($21 Value) FREE – Expires 6/11 Macxvideo AI ($39.95 Value) Free for a Limited Time – Expires 6/22 The Ultimate Linux Newbie Guide – Featured Free content Python Notes for Professionals – Featured Free content Learn Linux in 5 Days – Featured Free content Quick Reference Guide for Cybersecurity – Featured Free content
    • Ignoring the ads, Google Play Store actually works and has no issues installing apps.
    • 2TB Samsung 990 EVO Plus SSD drops to a great price again by Fiza Ali The 2TB Samsung 990 EVO Plus SSD is currently available on Amazon, Samsung, and Newegg at a great price, only $0.44 higher than its historic low. So, if you have been wanting to upgrade your storage solution, you may want to check it out (purchase links down below). The SSD features NAND memory, delivering sequential read speeds of up to 7,250MB/s and write speeds of up to 6,300MB/s. For random read (QD32), the 2TB version reaches up to 1,000K IOPS, and for random write (QD32), it achieves up to 1,350K IOPS. Furthermore, it carries a Total Bytes Written (TBW) rating of 1,200. The 990 EVO Plus is equipped with Intelligent TurboWrite 2.0 for enhanced performance with large files. Moreover, the drive features a nickel-coated controller that helps manage heat, reduce power usage, and prevent overheating. The SSD supports both PCIe 4.0 x4 and PCIe 5.0 x2, promising faster data transfer speeds and better performance. Additionally, with Samsung's Magician Software, the SSD keeps its firmware up to date, adds extra security, and allows for continuous drive health monitoring. Finally, the Samsung 990 EVO Plus SSD comes with a five year limited warranty, offering long-term reliability and peace of mind. 2TB Samsung 990 EVO Plus SSD: $129.99 (Amazon US) - $129.99 (Samsung US) - $129.99 (Newegg) This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here. Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days. You can also check out other SSD deals here. For hard disk drives, you can head over to our HDD deals section to see if anything from there matches your requirements. Make sure you also browse through Amazon US, Amazon UK, and Newegg US to find some other great tech deals. As an Amazon Associate, we earn from qualifying purchases.
  • Recent Achievements

    • Week One Done
      Adam Todd earned a badge
      Week One Done
    • Contributor
      Ed B went up a rank
      Contributor
    • One Month Later
      moporcho earned a badge
      One Month Later
    • One Month Later
      Parotel earned a badge
      One Month Later
    • Reacting Well
      Cryptecks earned a badge
      Reacting Well
  • Popular Contributors

    1. 1
      +primortal
      202
    2. 2
      snowy owl
      146
    3. 3
      ATLien_0
      133
    4. 4
      Xenon
      120
    5. 5
      +FloatingFatMan
      109
  • Tell a friend

    Love Neowin? Tell a friend!