workday formula slowing down computer

[cartica]

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

[TMS]

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

[cartica]

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

[Jonmo1]

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

[cartica]

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

[Jonmo1]

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?

[TMS]

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