Home > How To > How To Unshare A Workbook In Excel 2010

How To Unshare A Workbook In Excel 2010

Contents

Using "Highlight Changes", it will show a user made a change, but from talking with the users it is clear the user did not make the change. Anyone got any ideas? I've tried to save it this way and reload and other > >such combinations without luck. If your version of Excel is 2003 or earlier, Select Tools > Share Workbook from the menu bar and click on the Editing tab. Source

Last edited by TUSSFC; 05-20-2009 at 12:56 PM. Did this article help you? Will that allow more than one person to use the workbook at the same time, so for example; one person can issue lockers starting with #2001, while another person beginning with So his machine on the shared workbook was the only machine that showed incorrect information. http://www.wikihow.com/Unshare-an-Excel-Workbook

How To Unshare A Workbook In Excel 2010

Then it will no longer load. m0le Guest Update: I came up with something that worked.... Can you tell me what Protect Shared Workbook does? Get news about the products and tech you really care about.

We have a workbook that has mysteriously become "Shared". (Of course, that old PITA Mr. m0le > <> wrote: > > >I have a workbook with two marcos in it. any work around solution? How To Unshare A Workbook In Excel 2016 You can only upload photos smaller than 5 MB.

Today my boss said he had an incident where he made an entry and came back the next day and a different date was in the cell. Any help much appreciated. I tried to go into tools, protection, unshare and it changes the option in the menu to show share & protect but the workbook itself is stuck on share in the http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/unable-to-unshare-workbook/4d869532-99ee-474f-adec-adc39ba74433 I tried to go into tools, protection, > >> >unshare and it changes the option in the menu to show share & protect but the > >> >workbook itself is stuck

m0le Guest This is where i ran into the problem... How To Unshare An Excel File 2016 Once everyone is logged out of the workbook, proceed to the next step. 5 Unshare the workbook. suppose there are only two users of a shared workbook, namely A and B. It doesn't allow you to input a passwor Delete Empty or 'Broken' Named Ranges (#REF!) - This macro will delete named ranges which refer to empty or #REF!

How To Turn Off Workbook Sharing In Excel 2013

Requirement: I want this sheet as read-only to all users and update access to some users . http://www.pcreview.co.uk/threads/cant-unshare-workbook.3848427/ Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel General Can't unshare workbook To get replies by our experts at How To Unshare A Workbook In Excel 2010 All rights reserved. Unshare Excel 2016 You will be a Save the Current Worksheet as a New Excel Workbook File - This Excel Macro will save the currently visible/active worksheet (the one that you see when you

Yes No Can you tell us more? this contact form I then share the workbook. I tried to go into tools, protection, >> >unshare and it changes the option in the menu to show share & protect but the >> >workbook itself is stuck on share Quote: Private Sub Workbook_Open() With Sheet1 .Protect Password:="Secret", UserInterfaceOnly:=True .EnableOutlining = True End With End Sub After enabling 'Share Workbook' and re-opening the file it presents the following error: Quote: Run-time Excel Unshare Workbook Greyed Out

Yes No Cookies make wikiHow better. Unsharing and sharing again seems to make no difference. Excel tracks the changes in the Excel workbook, and then merges everyone’s work at a later date. http://homeshareware.com/how-to/how-to-unshare-an-excel-file-2013.html Try the command later".

so it is NOT already protected. Excel Shared Workbook 2013 It will not let me debug this error because you cannot open VBA while shared. m0le >> >> <> wrote: >> >> >> >> >I have a workbook with two marcos in it.

Any ideas anyone?

He closed Excel and reopened the shared workbook, and the date that had been incorrect magically corrected itself. m0le > >> <> wrote: > >> > >> >Gord, > >> > thx for the reply but if you read the original post I stated i tried that > >> By continuing to use our site, you agree to our cookie policy. Excel 2010 Shared Workbook m0le Guest I have a workbook with two marcos in it.

More questions I was working on a large Excel spreadsheet. I did get something to work though. I've tried protecting, unprotecting and then unsharing with no luck. http://homeshareware.com/how-to/how-to-unshare-calendar-in-outlook-2010.html Let me know if this makes sense or you will require additional information to lend a hand.

They get this when trying to save the file, or when I try to see who is in the file (tools -> Share workbook). I am coming a long thanks to you! m0le <> wrote: >I have a workbook with two marcos in it. Becomean Author!

m0le > <> wrote: > > >"I tried to go into tools, protection, > >unshare and it changes the option in the menu to show share & protect but the > As soon as the user closes the file it is magically unlocked and people can save/do whatever. Any xls files in the xlstart folder will start whenever an Excel sheet is opened. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc.

Back to Top