Editing a formula in multiple files

[jhungutierrez]

• Is there a way to automate changing the formula of multiple Excel files with different file names and directories but the same tab and cell address?

Scenario:

I created an Excel template to used by 70 users (an electronic class record). The formula is hidden and protected by a password. This template was disseminated and used by faculty members. I later found errors in the cell address. It will be very tiring if I am editing all their electronic classrecord one by one.

Is there an applet which if users run this, changes will be made in their excel file while it is opened? thank you for your help

 

[Ron de Bruin]

You can run a macro that do the job for you like this : Change cell or range in all workbooks in a folder

Or send them a workbook with code that let the user select the file and open it and make the changes and save it