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
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
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 - Retired Excel/VBA Consultant
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
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
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
that didn't seem to do it. is there a way to replace today()? or another option besides workday?
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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks