+ Reply to Thread
Results 1 to 4 of 4

Adding formula to sheet takes forever

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    Sheffield
    MS-Off Ver
    2007
    Posts
    32

    Adding formula to sheet takes forever

    I am trying to earn some brownie points at my work by automating some of the 'simpler' excel reporting tasks. One such report requires me to use 3 different columns to find unique entries from a sheet of date (12000 rows long). A sheet on another table then counts these unique entries.

    I have written the following code which works ok but takes around 7 minutes to complete. It takes the same amount of time regardless of disabling automatic calculations.

    Please Login or Register  to view this content.
    Can anyone shed any light as to why or offer any suggestion to fix it?
    Last edited by alansidman; 05-14-2019 at 09:04 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Adding formula to sheet takes forever

    Code Tags Added
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Adding formula to sheet takes forever

    Also disable Screen Updating and see if that makes a difference. You have a lot of calculations going on.
    Last edited by alansidman; 05-14-2019 at 10:53 AM.

  4. #4
    Registered User
    Join Date
    02-06-2013
    Location
    Sheffield
    MS-Off Ver
    2007
    Posts
    32

    Re: Adding formula to sheet takes forever

    Thanks Alan.

    screen update and alerts are both disabled. The time it takes to add the formula is still dispoportiante to perfoming the actions manually.

    EDIT: Ignore this double checking it's taking just as long doing it manually. I'm sure it didn't do this initially. I'll investigate further.
    Last edited by mdex; 05-14-2019 at 09:46 AM.

+ 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] Creating a macro to replace a formula that takes forever to calculate
    By PaulM100 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-03-2018, 09:49 AM
  2. Macro Takes forever To Execute
    By daveyc18 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2014, 11:14 AM
  3. VBA that hides rows with 0 takes FOREVER to run
    By Sky188 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-28-2013, 04:04 PM
  4. Excel Sheet takes forever to save
    By JohnGault82 in forum Excel General
    Replies: 2
    Last Post: 02-09-2011, 04:41 PM
  5. Copying column w/ VBA takes forever
    By patatvs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2010, 01:42 PM
  6. [SOLVED] Excel Moving sheet between workbooks takes forever on some workstations
    By John M. Mach, MOUS Master, MCSC in forum Excel General
    Replies: 5
    Last Post: 11-18-2005, 12:15 AM
  7. Workbook takes forever to open
    By drgreig in forum Excel General
    Replies: 4
    Last Post: 08-11-2005, 03: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