I have managed to solve the problem myself, I had mistakenly moved a
sheet into the workbook and the named ranges associated with it were
all referenced to the originl workbook.

Sorry for taking up anybodies time.

Tim