Results 1 to 4 of 4

Extremely Slow Macros

Threaded View

  1. #1
    Registered User
    Join Date
    03-26-2021
    Location
    Birmingham, Alabama
    MS-Off Ver
    Office 2016
    Posts
    7

    Extremely Slow Macros

    I am a complete novice when it comes to VBA. In fact, I am completely self-taught in Excel, which means I tend to do things via recorded macros when I can and as soon as I find something that works for my issue, I stick to that.

    A little about the file: I work in manufacturing and have created my own file to calculate machine load and capacity. The original file works alright. Then I made a second file which is inspired by the first, but has more options to it.

    The original file only calculated by annual volume for 4 years from one source of volume data. (300 tools across 32 machines)

    This new file can have one of two volume sources (Projected or Customer Given) and shows 8 years of data, either annually or quarterly. This one has a quarterly load and heat map, as well. (Also 300 tools across 32 machines)

    I have code that works in the new file, but it runs insanely slowly. My guess is that is because all my macros, graphs and calculations interract with multiple sheets.

    In the attached file, I scaled a lot of things down so that I can upload:
    Program codes from 25 down to 4
    Quarters & Years from 2021-28 down to 2023-25
    Machines from 32 down to 4

    That sped it up a TON, so I think the problem may be my massive quantity of data... So here is the question: Is there something I can do with my macros, given the stupid way I set this up because I don't know VBA (or really any appropriate Excel methods), that will help speed this up when I go back to 8 years and 300 tools? Or am I just out of luck because this comes out to several thousand data points?

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel extremely slow now
    By bittah.wanderer in forum Excel General
    Replies: 4
    Last Post: 08-31-2020, 11:33 PM
  2. OFFSET functions are making my macros extremely slow
    By amros in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-11-2017, 03:25 AM
  3. Extremely slow macro!
    By PSm1th29 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2010, 06:27 AM
  4. Excel is extremely slow now
    By Martindelica in forum Excel General
    Replies: 0
    Last Post: 05-01-2007, 08:32 PM
  5. [SOLVED] Extremely slow file
    By Jay in forum Excel General
    Replies: 3
    Last Post: 07-10-2006, 08:19 AM
  6. [SOLVED] Macros making file saving extremely slow.
    By Donald Speirs in forum Excel General
    Replies: 1
    Last Post: 01-20-2005, 07:06 PM
  7. [SOLVED] Macros make file saving extremely slow.
    By Donald Speirs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2005, 02:06 PM

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