Shared file

[jennifer]

We have a file saved on the server which has suddenly become a shared
file. It wasn't before and we had a number of people accessing it from
different computers. None of our other files have become shared like
this one. How do I change it from being shared as it won't let me copy
sheets because of this. I create a new sheet each month and use
another as a template. I can copy and paste cells but would prefer to
be able to just copy the sheet.

Thanks

Jen

 

[Dave Peterson]

Tools|Share workbook|Edit tab

The option isn't too far from worksheet/workbook protection. I bet it was a
slip of the mouse--or it was done by another user on purpose???)

 

[jennifer]

Thanks for the help. I was looking in Tools|Options and
File|Properties.

It was done by another user who didn't know what they did to get it
that way.

Jen