Some answer regarding formulas being turned off with VBA

[tonywatsonhelp]

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

 

[DataBlake]

if you're looking to speed up a workbook's ability to do calculations or reference other workbooks/pages then i would suggest creating a way for your user to use VBA code that does said calculations.
the only other thing i could think of in response to your post would be changing the calculations from "automatic" to manual. To my knowledge this affects the entire workbook.
but if you're working with lots of data, calculations, or changes VBA is the way to go.