- 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?
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