P
PatrickS
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)
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)