#1   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default unmerge cells

You should make a backup copy of the file, because it may have history
that you'll need later. The history would be deleted if you remove sharing.

Then, on another copy of the file:

Choose ToolsShare Workbook
On the Editing tab, remove the check mark from 'Allow changes by more
than one user at the same time.'
Click OK

Susanstef wrote:
Thanks Debra!! Yes, I can see now that the file appears to be "shared"
(I can only tell this by the title [shared] after the file name at the
top. As I said, I have inherited this file, is there someway to
"unshare" it or do I have to save it as a different file to get rid of
the shared status??

Susan




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #2   Report Post  
Posted to microsoft.public.excel.misc
Susanstef
 
Posts: n/a
Default unmerge cells


Thanks again, Debra. I'll do that.
Susan


--
Susanstef
------------------------------------------------------------------------
Susanstef's Profile: http://www.excelforum.com/member.php...o&userid=35615
View this thread: http://www.excelforum.com/showthread...hreadid=554346

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
how do i protect cells in a shared worksheet Debi Excel Discussion (Misc queries) 3 September 30th 05 11:15 PM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"