+ Reply to Thread
Results 1 to 7 of 7

workday formula slowing down computer

  1. #1
    Forum Contributor
    Join Date
    07-21-2013
    Location
    washington dc
    MS-Off Ver
    Excel 2010
    Posts
    469

    workday formula slowing down computer

    HI,

    My workday formulas are slowing down my excel file. I have a sheet with spots for 5 days. Today is in b5, and then the the other 4 days will be prior 4 weekdays.

    Thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,842

    Re: workday formula slowing down computer

    Thank you for sharing. What would you have us do with that information? No workbook, no worksheet, no formulae, no data ... options are limited.

    =TODAY() is a volatile Excel function which will cause re-calculation. What does the rest of the workbook look like? Are there lots of formulae? Has it always been slow? Or has something changed? Do you see "calculating" in the bottom right hand side of the window?

    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-21-2013
    Location
    washington dc
    MS-Off Ver
    Excel 2010
    Posts
    469

    Re: workday formula slowing down computer

    Here is attached. Yes, it recalculates. This is not the main sheet, just the workday formulas. Any alternatives, to today,workday. not sure if weekday also slows things down. Yes, the workbook has a lot of tabs and formulas like sumifs/sumproducts, etc.


    workday formula.xlsx

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: workday formula slowing down computer

    Don't reference TODAY() in the workday formulas.
    You already have Today in B3.

    So replace TODAY() in all those workday formulas (and ANY formula that uses Today()), with just $B$3

  5. #5
    Forum Contributor
    Join Date
    07-21-2013
    Location
    washington dc
    MS-Off Ver
    Excel 2010
    Posts
    469

    Re: workday formula slowing down computer

    that didn't seem to do it. is there a way to replace today()? or another option besides workday?

  6. #6
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: workday formula slowing down computer

    Did you replace ALL references to TODAY() with $B$3 (except B3 itself).
    You can use the find/replace tool to do that.

    What about conditional formatting, do you have anything referencing today() in there?

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,842

    Re: workday formula slowing down computer

    The example probably isn't representative of the whole workbook so may not react in the same way.

    However, for the purpose of the example, see the updated sample workbook.

    Regards, TMS
    Attached Files Attached Files

+ 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. WORKDAY Formula
    By Simoin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-05-2014, 08:32 AM
  2. Workday in formula
    By WiserGuy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2014, 11:30 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. Workday.INTL or Workday function issue
    By junoon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 03:14 PM
  5. Workday Formula
    By Blake 7 in forum Excel General
    Replies: 2
    Last Post: 02-14-2012, 05:19 AM
  6. Conditional Formatting Is Really Slowing Down My Computer, Any Suggestions?
    By Orangeworker in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-10-2010, 03:28 PM
  7. Workday Formula
    By Gos-C in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2005, 03:47 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