+ Reply to Thread
Results 1 to 1 of 1

My laptop suddenly takes 10 times as long to run VBA codes

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    16

    My laptop suddenly takes 10 times as long to run VBA codes

    EDIT: Fixed it so nvm. The issue is related to plugging the laptop away from the monitor and turning it back in which obviously shouldn't cause problems. But for w/e reason you need to restart the laptop without the monitor being connected to it. Otherwise it causes performance related issues. As a consequence excel now takes up 16% of CPU ressources from 4%.

    Apologize if I am writing this on the wrong forum since I am not actually asking help VBA directly.

    I had a few codes that I used to run and analyze large sets of data. They worked fine until today where my laptop now takes forever to run through the codes. And nothing has changed with the codes or with my computer. I spent hours today trying to optimize the code, but it still barely help. I also noticed that when VBA opens a new Excel file it takes like 8 seconds to load it where it used to open almost instantly.

    I think the explanation might be that my laptop suddenly decided to spend alot less ressources on Excel because I don't hear any "working sound" anymore. Usually you could hear the laptop working when running through a large code, but it doesn't do that anymore. Instead it's completely silent leaving me to believe its not using the same amount of power to run through the codes.

    So I apologize once again for the untraditional question, but I wonder if anyone else has run into a similar problem or has a potential solution to it.

    Thanks in advance.
    Last edited by MathiasH; 08-27-2016 at 06:51 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] =IF and =SUMIF formulas creating long long long data processing times.
    By comp in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 03-26-2014, 02:59 PM
  2. Calculation takes long time
    By dorend in forum Excel General
    Replies: 10
    Last Post: 12-13-2011, 06:17 PM
  3. Long code takes an age to run
    By E3iron in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-05-2009, 07:38 AM
  4. VBA takes too long to execute..
    By ruchi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2009, 04:53 AM
  5. My Code takes too long to execute
    By coreytroy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2008, 12:12 AM
  6. Takes way to long to save.
    By RickABC in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 05-20-2008, 03:43 AM
  7. [SOLVED] Save takes long time
    By Jan in forum Excel General
    Replies: 2
    Last Post: 02-15-2006, 02:10 PM
  8. Counting how long a Macro takes to run
    By Diane Alsing in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2005, 02:06 PM

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