Hi
I read this article on Microsoft's website: https://support.microsoft.com/en-us/...of-calculation
I want to know if there is any possibility that I can have one workbook which has automatic calculations, and another workbook which has manual calculations open simultaniously. I am aware that the article implies that my question is not possible, so I am up for any solution, since the problem compromises my work
Last edited by JCtheRULEr; 04-12-2017 at 04:33 AM.
You can do that by VBA, check here: Excel Programming / VBA / Macros
Hi,
a possible alternative: you could disable calculation by setting the EnableCalculation property to False of one or more sheets , leaving Workbooks on automatic calculation.
Right click on a sheet tab and select the command view code: in the property windows you can set to false "EnableCalculation".
VBA can offer more convenient solutions.
Just for sharing another idea.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Thank you guys
You are welcome
repsolv.gif
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks