Excel Formula Performance and checking the possibility with VBA

Dear all,

I have attached Excel.
Problem I have with that excel is, every time I add an entry in either WD or AD tab, it is calculating all the Formulas again and causing few issues.

is it possible at all to a Button and have the calculations only after pressing Calculate Button?
Thanks a lot!

Best Regards,
D.

Yes for sure. If you set calculation to manual under the Formulas ribbon tab, you can refresh the calculation by pressing F9. If you want to add a button that will trigger the recalculation, you can just record a macro of you pressing F9 and Excel will take care of the syntax - it should record something like:

Please Login or Register  to view this content.

Then you can just add a button and map it to the macro (right click button > Assign Macro).

However to do the above you need to save the document as xlsm not xlsx

I m sorry, Might I request you to help me put it in the excel? I have 0 experience with Macros.
Very kind of you.. Sorry...

It is not difficult to do and would be good if you learnt as it would save you time in the future and increase your learning. Your name is not the same as the start of the thread, so you have not posted a workbook to add to.

The following 2 links should set you off in the right direction if you follow them to do what you want to achieve

https://peltiertech.com/how-to-use-someone-elses-macro/

https://peltiertech.com/how-to-assig...tton-or-shape/

thank you, I will try..

Other ID is also mine, but, I am not using it, but browser (in office machine) stores the ID and password and posts it.