+ Reply to Thread
Results 1 to 2 of 2

Aggregate function slowing down my file

  1. #1
    Registered User
    Join Date
    08-22-2014
    Location
    Monterrey
    MS-Off Ver
    2010
    Posts
    30

    Aggregate function slowing down my file

    A few weeks back I learned about the "=AGGREGATE()" function and been using it ever since. It works as it should, but I noticed that since this function was added to my file, the time it takes to open / Update the file has increased heavily.

    Any ideas why?
    Is there another way to get the result I need (extract the MAX() number from a range while ignoring the errors) without the AGGREGATE function?

    Regards,

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Aggregate function slowing down my file

    Can you post a sample formula?

    If you are using whole column ranges - don't. Use a smaller range, possibly large enough to cater for future expansion of data, but no more
    Audere est facere

+ 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] VBA Aggregate Function
    By Gregor y in forum Access Programming / VBA / Macros
    Replies: 9
    Last Post: 02-27-2017, 03:17 AM
  2. VBA code is slowing down the worksheet function
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-07-2016, 09:09 AM
  3. Big conditional formatting formula slowing down file, need help to rewrite
    By henkisdabro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2014, 01:27 AM
  4. Many Combo boxes slowing down file
    By Commercial_Coder in forum Excel General
    Replies: 1
    Last Post: 12-07-2012, 07:35 PM
  5. Custom function slowing workbook speed
    By PIPPIBOOKS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-04-2008, 05:30 PM
  6. View zoom slowing opening of the file
    By ConnieM in forum Excel General
    Replies: 0
    Last Post: 07-27-2006, 06:10 PM
  7. Aggregate function
    By stefantem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2006, 04:47 AM

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