thanl you for your response. Good suggestion, I looked at that but the sheet was not protected. It may have been due to links in other work books. I played around with differnt ways of opening it and reopened the program. Not sure what actually fixed it but it seems to be working ok now.