im doing an excel automation of daily trackers, when excel links are disabled, it works fine, but in prod, since files are linked to it, it keeps calculating multiple times. Any when i do data manipulation, this calcualtion doesn’t happen.
A simple workaround with no code change – just keep an excel open in manual mode (excel formulas mode - manual mode). whatever excels you open after this will be opened in manual mode.
You can create a dummy excel and open this using excel application scope and then invoke your workflows inside this scope.
3 Likes
This worked without much hassle. Thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.