tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I've tried googling this and not had a lot of luck as get a lot of conflicting views.
I'm looking to speed up my workbook by turning formulas off and only switching the on when I need them.
I'm getting a bit stuck as it doesn't seam to do what I expect, I was hoping someone that knows could let me know if I can do the following?
Can I turn off formulas just for one workbook? one of the problems is people have more than one excel doc open and then start saying the other one is not working correctly, I can't edit the other workbook as some work in the background so it not a case of on activate...… as this won't help.
also if I use the caculate now vba does it run all calculations or just active sheet?
Thanks
Tony
I've tried googling this and not had a lot of luck as get a lot of conflicting views.
I'm looking to speed up my workbook by turning formulas off and only switching the on when I need them.
I'm getting a bit stuck as it doesn't seam to do what I expect, I was hoping someone that knows could let me know if I can do the following?
Can I turn off formulas just for one workbook? one of the problems is people have more than one excel doc open and then start saying the other one is not working correctly, I can't edit the other workbook as some work in the background so it not a case of on activate...… as this won't help.
also if I use the caculate now vba does it run all calculations or just active sheet?
Thanks
Tony