Forum Discussion
Excel was running very slow
I am using Microsoft Excel for Mac Version 16.26 as part of office 365 subscription. I maintain invoices of my business into one spreadsheet with many different sheets as they reflect vendors. I ...
If you are using any of the volatile functions like INDIRECT() or OFFSET() and have lots of these in your formulae, that could be the cause of the slowing down.
Do you need to have separate sheets for each vendor?
Could you not just have all the data in your one sheet, and just Filter for any particular vendor? That would get rid of the need for lots of your formulae.
Roger Govier I don't have functions like INDIRECT() or OFFSET(). Mostly are something like these F36+(F36*$R$41), RIGHT(D397, 2) like these simple functions.
Also having different sheets for each vendor I can manage data differently for each particular vendor.
My problem still exist.