Analysis & Design of Weld Groups

Just to close off; the recent submission of an updated file by the Shaiq Khan has resolved the issue. The spreadsheet is now fully functional and does just what I need. Thanks!

Shaiq emailed an update
The updated calculation has an option to find stress resultant using SRSS OR EuroCode (Von Mises) formula.

Thanks for the reply John. The cell I need to change is actually provided as an option for the user (as a drop-down box), but (perhaps inadvertently) has been locked so that the drop-down selection cannot be changed.
Perhaps I'll try the "back door" as suggested by AFingle. I'll also check the other suggested resources, but I'm looking for a tool (SI units) that uses the von Mises approach for combining shear and direct stress, as that is what the design rules (Australia, AS3990) use to establish stress limits.

technouk spreadsheets are generally password locked which keeps them safe from modification but difficult to modify for your own needs. There are a couple of other repository items which I think you will find both useful and easy to modify:
1) WELDGRP.xls - One of Alex Tomanovich's great spreadsheets. They are protected but not with a password. Just download and unprotect worksheet. There are elastic and ultimate strength methods. A metric version can also found here WELDGRP Metric.xls.
2) LineSec.xls - This is good for any section made up of lines, welds lines included. I find it useful because the weld line does not have to be the same thickness each line can have its own thickness property. Analysis is elastic. This calculation is mine and all the working is shown with XLC equations so it should be easy to modify.
3) ThinWallProp1.xls is a great calculation from Yakov Polyakov. This will give the ultimate strength of a weld line. From memory I think all lines have the same thickness.
One or other of these methods has got me out of all the weld static strength problems I have encountered.

British standards, but an excellent resource.