Problems with a workbook that thinks it's shared

[Guest]

I have a spreadsheet that is used as a template to generate other
spreadsheets that are then sent out to other users to fill out and then send
back. However some users have reported errors occuring within the
spreadsheets that get generated, albeit intermittently.

What's weird is that the generated spreadsheet shows all the symptoms of
being shared (the code falls over when it tries to unprotect a sheet for
example), but going into the 'share workbooks' option shows it as unshared.
However sharing it and then unsharing it seems to fix the problem.

There is this workaround of sharing and unsharing, but the users - also our
customers - find this unacceptable. I need to understand why this is
happening and was wondering if anybody here could point me in the right
direction? (I'm stumped as I can't reproduce this problem myself)

 

[Guest]

I don't know if it's the correct answer, but what I've run into with my
shared workbooks (and what it sounds like) is that there could be some
corruption to this workbook you're having problems with. You may want to try
creating a new copy of that workbook - or better yet rebuilding it from
scratch - then make sure it NEVER gets set/saved as a Shared workbook, as
that setting tends to cause issues and corruption in Excel workbooks.

Hope that helps!