+ Reply to Thread
Results 1 to 2 of 2

Why is my program hanging?

  1. #1
    Registered User
    Join Date
    08-25-2010
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Why is my program hanging?

    My excel hangs multiple time a day (5-20) and I need to fix the problem.

    I use DDE links to download data from Thomson Reuters. Maybe 100 different links with 400-500 derivative calculations in all. I bring in data for two sheets where sheet A references data on sheet B for some calculations.

    It works fine most of the time. TR has checked my memory and connection response time and both are more than adaquet.

    Could I be pushing on the limits of the program? How can I get further insight into the problem.

    P.S. I tested Office 2010 Excel and have the same issues...

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Why is my program hanging?

    Could I be pushing on the limits of the program?
    Sounds like it.

    It's really hard to tell without more info about the sheet.

    What happens if you delete half the data sources? If it suddenly fixes we probably have an answer.

    There may be lots of ways of refining your queries, depending on the situation - if you upload an obfuscated version we may be able to help more.
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1