Removing Office Plus formulas from workbook with multiple sheets?

Is there any way to easily remove Office Plus formulas from a workbook that may have multiple sheets of different cubes. My users want the ability to press a button and all the Office Plus formulas generated within the multiples sheets get removed and behind leave any formulas that they added in the workbook.

Thanks in advance.

Find more posts tagged with

Infor EPM Discussions

Comments

unknown

Hi Alison,

in my oppinion the only way to achive this, is by a VB(A) Makro. At least for version 11. I don't know, if there is something in version 12 you can use out of the box. Which Office Plus Version do you use?

Regards, Karsten

Ralf Zerfass

Good Morning

I agree with Karsten, I think there is no other way as using a macro for this.

Please find attached “my” macro, I’m using for that.
Comments are in german, but I hope that it is mostly self-explaining.

However, no support or no warranty from my side, please test before using in production environment.

Have fun,
Ralf

Von: Karsten Kienemann
Gesendet: Freitag, 15. Mai 2020 07:50
An: dEPM-discuss@lists.inforcommunities.com
Betreff: [dEPM-discuss] - RE: Removing Office Plus formulas from workbook with multiple sheets?

Hi Alison,

in my oppinion the only way to achive this, is by a VB(A) Makro. At least for version 11. I don't know, if there is something in version 12 you can use out of the box. Which Office Plus Version do you use?

Regards, Karsten

-----End Original Message-----

Alea-Formeln ersetzen (2).txt

Copyright © 2025 Infor. All rights reserved.