How to Share & "Un-Share" Worksheets

  • Thread starter Thread starter crwiseman
  • Start date Start date
C

crwiseman

I have a worksheet on a network drive that several of us share. I need
to control-copy a sheet to start a new sheet formatted like the current
one. But alas, Excel says that you can't do a control-copy on a shared
worksheet. How do I "un-share" the worksheet, do the control-copy
formatting, then re-share the worksheet? Thanks!
 
In Tools, "unshare" the worksheet, make your copy, then go back into Tools
and restore the "share" capability.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cannot save worksheet because of sharing violation 2
Moving / sharing Macros between workstations 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to enable the Unprotected Worksheet menu 2
excel 2003 wont sort when shared 1
How do I apply print settings to all worksheets 1
Un-Synchronous Panes 3
Conditional formatting for shared worksheet? 2

Back
Top