+ Reply to Thread
Results 1 to 4 of 4

Excel Crashing on Refresh of Data

Hybrid View

  1. 09-12-2013, 12:29 PM #1
    chris.slater
    chris.slater is offline
    Registered User
    Join Date
    03-12-2012
    Location
    Manchester, England
    MS-Off Ver
    MS 365
    Posts
    57

    Excel Crashing on Refresh of Data

    Hi All
    I am now officially tearing my hair out with this one.
    I have a report that uses external data to feed a Pivot Table.
    I noticed that the data source had been turned off automatically by Excel and turned it on and added the file location to the trust centre.
    I also set the data to refresh when the workbook is opened.
    I saved the file and then tried to refresh the data which caused Excel to crash. Of course now I can't open the file either because when it attempts to refresh itself on opening that causes Excel to crash as well.
    HELP PLEASE!!

    Addendum:
    I have removed the Trusted Location which has caused Excel to disable the connection again. This has solved the crash on opening but I still can't refresh the data.
    Last edited by chris.slater; 09-12-2013 at 12:37 PM.
    Reply With QuoteRegister To Reply
  2. 09-12-2013, 04:14 PM #2
    2001jesper
    2001jesper is offline
    Registered User
    Join Date
    11-05-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: Excel Crashing on Refresh of Data

    Split your pivot into 2 - if you are using GetPivot, then this should not give you any problems as long as your basic parameters are the same. Otherwise be patient and let it refresh - it takes times with large data-sets. "Not responding" on top of the screen does not always mean that excel have crashed
    Reply With QuoteRegister To Reply
  3. 09-16-2013, 04:10 AM #3
    chris.slater
    chris.slater is offline
    Registered User
    Join Date
    03-12-2012
    Location
    Manchester, England
    MS-Off Ver
    MS 365
    Posts
    57

    Re: Excel Crashing on Refresh of Data

    Hi Jesper
    I fear it is a proper crash as I get the error message "Excel has stopped working etc.."
    The error comes when I try to refresh the source data, not the Pivot Table which is just referencing the range that contains the source data.
    Reply With QuoteRegister To Reply
  4. 09-16-2013, 06:24 AM #4
    JosephP
    JosephP is offline
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Excel Crashing on Refresh of Data

    it sounds as though there is a problem with the data source
    Josie

    if at first you don't succeed try doing it the way your wife told you to
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Refresh XML data from web in Excel
    By nunonog in forum Excel General
    Replies: 2
    Last Post: 08-28-2013, 06:37 AM
  2. Excel Refresh All Data From Web Crashes?
    By nobodyukno in forum Excel General
    Replies: 4
    Last Post: 08-06-2013, 09:01 AM
  3. Excel melts down when I try to refresh data
    By RollerRagerMD in forum Excel General
    Replies: 4
    Last Post: 07-23-2013, 10:36 AM
  4. refresh excel data
    By rchiu5hk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2009, 01:58 AM
  5. refresh data from a intermediate excel data file (not opened)
    By Matthieu Gaillet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-01-2005, 10:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1