Formula corrections across a range of files (standard layout)

[splash]

Hi all

I have an issue that I would be very appreciative of your help with:

I have a large number of excel files with a standard worksheet in a standard layout. I need to amend formulas in a particular column in all worksheets - is there a way to do this other than opening each workbook and amending the formulas manually?

Any assistance with this would be very much appreciated

Thanks a lot in advance
Splash