Nikolay, that fixed it. I didn't know about that option. The missing sheet appeared to be selected but there was a check missing next to <current file>. Once I checked this to force check all, it worked.
Presumably this will fix the bug that has been bugging me 🙂
Thank you.