+ Reply to Thread
Results 1 to 4 of 4

Program really slows down

  1. #1
    Forum Contributor
    Join Date
    05-04-2015
    Location
    Atlanta GA
    MS-Off Ver
    2010
    Posts
    106

    Program really slows down

    I have a worksheet that uses a lot of macros and formulas. Over the course of 30 minutes, the program slows down to a crawl. So much so that I have to exit Excel and go back in. Is there any way to clear the cache while I'm still in the program?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Program really slows down

    Over the course of 30 min? what is happening?

  3. #3
    Forum Contributor
    Join Date
    05-04-2015
    Location
    Atlanta GA
    MS-Off Ver
    2010
    Posts
    106

    Re: Program really slows down

    for one, I have a randbetween(1,20) that buffers for about 5 seconds before it gives a number.

  4. #4
    Valued Forum Contributor
    Join Date
    11-27-2011
    Location
    usa
    MS-Off Ver
    Excel 2007, Excel 365
    Posts
    495

    Re: Program really slows down

    Instead of having people just trying to guess, why don't you provide an example of what you are dealing with?

+ 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. Macro slows down with each use
    By Mumps1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2019, 01:40 PM
  2. Macro slows down
    By bongielondy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2019, 07:00 AM
  3. VBA-How to program sizing and placing Excel window at the start of the program
    By dr.prakash in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2013, 11:45 PM
  4. [SOLVED] macro slows down
    By Gary Keramidas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2006, 07:45 PM
  5. Excel slows down for no(?) reason...
    By thekovinc in forum Excel General
    Replies: 0
    Last Post: 12-06-2005, 02:01 PM
  6. ifsum slows down calculations
    By Peter Nash in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 08:05 PM
  7. [SOLVED] ifsum slows down calculations
    By Peter Nash in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 05:05 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