How to share Excel file for multiple users and co-author a shared workbook

In this tutorial, you will find full details on how to share Excel workbook with other people by saving it to a local network or OneDrive, how to control user access to a shared Excel file and resolve conflicting changes.

These days more and more people are using Microsoft Excel for team work. In the past, when you needed to share an Excel workbook with someone, you could send it as an email attachment or save your Excel data to PDF for printing. While fast and convenient, the former method created multiple versions of the same document, and the latter produced a secure though non-editable copy.

The recent versions of Excel 2010, 2013 and 2016 make it easy to share and collaborate on workbooks. By sharing an Excel file, you are giving other users access to the same document and allow them to make edits simultaneously, which saves you the trouble of keeping track of multiple versions.

How to share an Excel file

This section shows how to share an Excel workbook for multiple users by saving it to a local network location where other people can access it and make edits. You can keep track of those changes and accept or reject them.

With the workbook open, perform the following steps to share it:

  1. On the Review tab, in the Changes group, click the Share Workbook button.
    Sharing an Excel workbook
  2. The Share Workbook dialog box will appear, and you select the Allow changes by more than one user at the same time. This also allows workbook merging check box on the Editing tab.
    Allow changes by more than one user at the same time.
  3. Optionally, switch to the Advanced tab, select the desired settings for tracking changes, and click OK.

    For example, you may want to have changes updated automatically every n number of minutes (all the other settings on the screenshot below are the default ones).

  4. Select the desired settings for tracking changes.

  5. Save you Excel file to a network location where other people can access it (the fastest way is by using the Ctrl + S shortcut).

If done correctly, the word [Shared] will appear to the right of the workbook's name as shown in the screenshot below:
Excel shared workbook

Now, you and your colleagues can work on the same Excel file at the same time. You are free to accept or reject their changes, and after the desired changes have been incorporated, you can stop sharing the workbook. Further on in this tutorial, you will find the details on how to do all this.

Note. If Microsoft Excel refuses to share a certain workbook, most likely it's because of one of the following reasons:

  1. Workbooks that have tables or XML maps cannot be shared. So, be sure to convert your tables to ranges and remove the XML maps before sharing your Excel file.
  2. To be able to share a workbook, some privacy settings need to be disabled. Go to File > Excel Options > Trust Center, click the Trust Center Settings… button, and under the Privacy Options category, uncheck the Remove personal information from file properties on save box.

How to share Excel workbook and protect change tracking

If you'd like not only to share an Excel file, but also to ensure that no one turns off the change history or removes the workbook from shared use, proceed in this way:

  1. On the Review tab, in the Changes group, click the Protect and Share Workbook button.
  2. The Protect Shared Workbook dialog window will show up, and you select the Sharing with track changes check box.
  3. Type a password in the Password (Optional) box, click OK, and then retype the password to confirm it.

    Though entering a password is optional, you'd better do it. Otherwise, there's little sense in using this option, because anyone would be able to remove the protection and thus stop the workbook sharing.

  4. Save the workbook.

Share Excel workbook and protect change tracking.

Clicking OK in the above dialog box will change the Protect and Share Workbook button on the ribbon to Unprotect Shared Workbook, and clicking this button will both remove the protection from the shared workbook and stop sharing it.

Note. If the workbook is already shared, and you want to protect sharing with a password, you must unshare the workbook first.

Protect worksheet vs. protect shared workbook

The Protect and Share Workbook option only prevents turning off change tracking in a shared workbook, but does not prevent other users from editing or deleting the workbook's contents.

If you want to prevent people from changing important information in your Excel document, you will need to lock some areas before sharing it ("before" is an important word here since the worksheet protection cannot be applied to an Excel shared workbook). For the detailed step-by-step instructions, please see:

Excel shared workbook limitations

When deciding to share your Excel file, please be aware that it may cause some troubles to your users because not all features are fully supported in shared workbooks. Here are some of the limitations:

  • Sorting and filtering by format
  • Conditional formatting
  • Merging cells
  • Excel tables and PivotTable reports
  • Charts and pictures
  • Data validation
  • Worksheet protection
  • Grouping or outlining data
  • Subtotals
  • Slicers and sparklines
  • Hyperlinks
  • Array formulas
  • Macros
  • A few more things

In fact, you will be able to use the existing features, but you won't be able to add or change them. So, if you'd like to benefit from any of the above options, be sure to apply them before sharing your Excel file. The complete list of features unsupported in shared workbooks can be found on Microsoft's web-site.

How to edit an Excel shared workbook

After you open a shared workbook, you can enter new or change existing data in a regular way.

You can also identify your work in a shared workbook:

  1. Click the File tab > Options.
  2. In the General category, scroll down to the Personalize your copy of Office section.
  3. In the User Name box, enter the user name that you want to display, and click OK.

Identifying your work in a shared workbook

Now, you can input and edit data as usual, keeping in mind the following limitations of shared workbooks.

How to resolve conflicting changes in a shared Excel file

When two or more users are editing the same workbook simultaneously, some edits can affect the same cell(s). In such situations, Excel keeps the changes of the user who saves the workbook first. When another user tries to save the workbook, Excel displays the Resolve Conflicts dialog box with the details about each conflicting change:
Resolving conflicting changes in a shared file

To resolve conflicting changes, do one of the following:

  • To keep your change, click Accept Mine.
  • To keep the other user's change, click Accept Other.
  • To keep all of your changes, click Accept All Mine.
  • To keep all of the other user's changes, click Accept All Others.
Tip. To save a copy of the shared workbook with all your changes, click the Cancel button in the Resolve Conflicts dialog box, and then save the workbook under a different name (File > Save As). You will be able to merge your changes at a later point.

How to force recent changes to override previous changes automatically

To have the most recent changes automatically override any previous changes (made by you or by other users), without displaying the Resolve Conflicts dialog box, do the following:

  1. On the Review tab, in the Changes group, click Share Workbook.
  2. Switch to the Advanced tab, select The changes being saved win under Conflicting changes between users, and click OK.

Have the changes being saved override the previous changes.

To view all the changes that have been made to the shared workbook, use the Track Changes feature on the Review tab, in the Changes group. It will show you when a particular change was made, who made it, and what data was changed. For more information, please see:

How to merge different copies of a shared workbook

In some situations, it can be more convenient to save several copies of a shared workbook, and then merge changes made by different users. Here's how:

  1. Share your Excel file to a local network location.
  2. Other users can now open the shared file and work with it, each person saving their own copy of the shared workbook to the same folder, but using a different file name.
  3. Add the Compare and Merge Workbooks feature to your Quick Access toolbar. The detailed steps on how to do this can be found here.
  4. Open the primary version the shared workbook.
  5. Click the Compare and Merge Workbooks command on the Quick Access toolbar.
    Compare and Merge Workbooks
  6. In the Select Files to Merge dialog box, select all the copies you want to merge (to select several files, hold the Shift key while clicking the file names, and then click OK).

Done! The changes by different users are merged into a single workbook. Now you can highlight the changes, so you can view all the edits at a glance.

How to remove users from a shared Excel workbook

Sharing an Excel file for multiple users can result in many conflicting changes. To avoid this, you may want to disconnect certain people from the shared workbook.

To remove a user from a shared workbook, do the following:

  1. On the Review tab, in the Changes group, click the Share Workbook button.
  2. On the Editing tab, select the name of the user you want to disconnect, and click the Remove User button.

Remove a user from a shared workbook

Note. This action disconnects users only for the current session, but does not prevent them from reopening and editing the shared Excel file again.

If the selected user is currently editing the shared workbook, Microsoft Excel will warn you that any unsaved changes of that user will be lost. You click OK to continue or Cancel to abort the operation and allow the user to save their work.

If it is you that have been disconnected, you can preserve your work by saving the shared workbook with a different name, then reopen the original shared workbook and merge your changes from the copy you've saved.

If you want to delete personal views of the removed user, switch to the View tab > Workbook Views group, and click Custom Views. In the Custom Views dialog box, select the views you want to remove, and click Delete.
Delete personal views of the removed user.

How to unshare an Excel file

When the teamwork has been completed, you can stop sharing the workbook in this way:

Open the Share Workbook dialog box (Review tab > Changes group). On the Editing tab, clear the Allow changes by more than one user at the same time… check box, and click OK.
Stop sharing the workbook

Excel will displays an alert that you are about to remove the file from shared use and erase the change History. If that's what you want, click Yes, otherwise No.


  1. Before clearing this box, make sure you are the only person listed under Who has this workbook open now. If there are other users, disconnect them first.
  2. If the box is uncheckable (grayed out), most likely shared workbook protection is on. To unprotect the workbook, click OK to close the Share Workbook dialog box, and then click the Unprotect Shared Workbook button on the Review tab, in the Changes group.

How to share Excel workbook using OneDrive

Another way to share an Excel workbook is to save it to OneDrive, invite your colleagues to work on it, and see each other's changes instantaneously. Microsoft calls it co-authoring.

Save and share a workbook

In Excel 2013 and Excel 2010, to save a workbook to OneDrive, perform these steps:

  1. Click File > Share > Save to Cloud.
  2. Invite people to collaborate on the workbook by typing their names or email addresses in the corresponding box.
  3. Make sure Can edit is selected in the dropdown list on the right (default) and click Share.

Save an Excel file to OneDrive and invite people to collaborate on it.

In Excel 2016, you can simply click the Share button in the upper-right corner, save the workbook to a cloud location (OneDrive, OneDrive for Business, or SharePoint Online library), type email addresses in the Invite people box, separating each with a semicolon, and then click the Share button on the pane (please see the screenshot below).

Clicking the Share button will send an email message to each person, a copy will be sent to you too, just in case. If you'd rather send the link yourself, click Get a sharing link at the bottom of the pane instead.
Sharing a workbook in Excel 2016

Co-author with other people

When your colleagues receive an invitation, they simply click the link to open the workbook in Excel Online, and then click Edit Workbook > Edit in Browser to edit the file.

Excel 2016 for Office 365 subscribers (as well as users of Excel Mobile, Excel for iOS and Excel for Android) can co-author in their Excel desktop application by clicking Edit Workbook > Edit in Excel.
Choose to edit in Excel or in browser.

Tip. If you are using Excel 2016, you can also click File > Open, and then select Shared with Me.

Now, as soon as other people start editing the workbook, their names will appear in the upper-right corner (sometimes pictures, initials, or even "G" that stands for guest). You can see other users' selections in different colors, your own selection is traditionally green:
See other users' selections in different colors.

Note. You may not see other people's selections if you are using a version other than Excel 2016 for Office 365 or Excel Online. However, all their edits to a shared workbook will appear in real time.

If multiple users are co-authoring, and you lose track of who is editing a specific cell, click on that cell, and the person's name will be revealed.
See who is editing a given cell.

To jump to the cell being edited by someone, click their name or picture, and then click the green box with the cell address.
Jump to the cell being edited by someone.

This is how you can share an Excel file with other users. I thank you for reading and hope to see you on our blog next week!

You may also be interested in

Category: Excel Tips

Table of contents

67 responses to "How to share Excel file for multiple users and co-author a shared workbook"

  1. Mike says:

    Once you unshare the workbook, can you then insert pivot tables and charts or do you need to save a new copy to start analyzing data?

  2. Vinay says:

    Hi Svetlana,

    I have very big matrix, suppose i select a particular cell, whether i can get the selected cell's first row and column( where the headings for the selected cell will be written).. I hope you got my query.

  3. Dave says:

    I am trying this now, and when one user filters, everyone's copy filters. Makes it really difficult to collaborate when filters are going on and off. Is there a workaround?

  4. David says:


    Can all the users edit and save changes simultaneously? Something like "Allow changes by more than one user at the same time" option.

    • Hi David,
      When two or more users are editing the same workbook simultaneously, some edits can affect the same cell or cells. In such situations, Excel keeps the changes of the user who saves the workbook first. To see how the possible conflicts can be solved, please read the section of this blog titled 'How to resolve conflicting changes in a shared Excel file'.

  5. Jubei says:


    I'm trying to share the workbook on an excel file with PowerPivot feature but was unsuccessful.

    Is this part of the limitation of Shared Workbook?
    Is there a workaround to resolve this?


  6. Astaeka says:

    Thanks for the details! Really appreciate it!

  7. Hossein says:

    Can we set up a password so that only the user who is sent the link can work on the file and the link cannot be shared with other third parties?

  8. Rithy says:

    With the recent update, Ms has disable shared feature. Is there a way to enable it again?

  9. Dan says:

    I'm trying to enable the conditional formatting and Protect sheet function for one of my excel files. The file is originally shared by my previous colleague and she left the company already. Is there a way to make it unshared by me to enable the disabled functions?

  10. Andre Schule says:

    Hi Svetlana,
    can you please advice me how to run my excel software in the cloud, thinking of using a NAS system ( need access from different PC's, not at the same time) My program has also Macros which needs to be used.

    Thanks for advice


  11. Ann Wong says:

    How to activate "Unshare Workbook" button? Cannot click at all. It was in grey colour button.

  12. Wendy says:

    How to activate "Unshare Workbook" button? Cannot click at all. It was in grey colour button.

  13. KaMiBi says:

    I have problem with shared xls files according to Office version. Users have Office version 2010 and 2013. And not every formula works properly sometimes it shows right values and sometimes it shows #Value error. Dragging not changed formula in version 2010 solves problem. Why is it like this?

  14. Roger says:

    If I share a workbook with multiple tabs set up for different people, is it possible to restrict the viewing and editing of worksheets ie John can only view and edit the tab labelled 'John' and not the tabs for Mary and David? The same limits would apply to Mary and David.

  15. daniela says:

    Hi, My excel workbook was shared but now it does not give the option neithr to share it nor to unshare it, do you know what could have happened? It happens with every excel we open , not only with one. Thanks

  16. StarchMD says:

    When I click on review, there is no share button.
    When I click Share, my Mac hangs for an hour.
    Any suggestions?

  17. ping says:

    I made the excel shared sheet. I want everybody can see the changes and how it happened. However, only me can see any changes and how it happened (when, How)other people made, the other people couldn't see any sign for the changes and even their own made.



  18. Keith Olsen says:

    I am sharing a spreadsheet and have sent out all of the shared invites, i sent one to a colleague to test and when she trys to open the spreadsheet it says it is locked by me, how do I unlock, I want all users to see it all the time and make simultaneous changes.

  19. Charlie says:

    I have a Macro workbook that 5 different people need to make changes. It is also available to others as 'read only' When someone who is read only forgets they have it in their open files, no one who needs to make changes can get in to make changes. How can I stop this from happening ? I only want one person to make changes at a time / but still allow others to read only while we make changes. Is this possible ?

  20. Kristi says:

    Help! At work, we have a spreadsheet that 4 of us update daily. Ever since we have gotten Excel 2016 in May, this spreadsheet doesn't show the correct data for everyone. If I update something and press save, then my coworker opens it and they cannot see what I have just saved and vice versa. We have used this spreadsheet for 9 years without an issue until now. Anyone know what is going on?


    • Erin says:

      It sounds like my coworker and I are having the same problem. We used to be able to work separately on the same spreadsheet, and our changes would both save/automatically be moved down a line if we were entering data on the same line without knowing it, no problem. Now, we're constantly having to go back and adjust what we're entering if we happen to be entering new data on the same line, and can't see each other's work like we used to.

      I can't see what she has done until she saves her document, and I save mine after that...and vice versa. SO ANNOYING. Please advise if anyone has figured out a way around this.

  21. Mayur says:

    If excel is opened at two places and I have track changes made in excel every second in either places. In short, I have to refresh it every second without closing the excel.

  22. Denise says:

    Good morning. We have 4 people sharing an excel spreadsheet which has been working fine for the last year, but now one person cannot save. It keeps coming up with

    "Your changes could not saved to 'Shed Workflow Information.xls' because of a sharing violation. Try saving to a different file.

    Could someone please explain why this could be happening all of a sudden.

    Thank you Denise

  23. Samson says:

    Please... I shared an excel file over a lan network but each time I tried opening it on other connected systems it opens as a read only document... Any suggestions on making the worksheet editable

  24. zam says:

    May I know How to add and remove the user in sharing doc?

  25. Joseph K R says:

    I have uploaded an excel sheet in onedrive and shared with team members. can we add new columns or rows while multiple users are updating the details in excel sheet at same time? is there any chances of loosing data ?

  26. Tobler says:

    Hi, i'm trying to disable share workbook. Just want to be sure tho, if i disable Share Workbook but left the file in a shared folder, will my colleagues still be able to access/edit the file (although one at a time)? The intention is to disable the Share Workbook feature as we already encountered a lot of conflicts, but file will still be accessible/editable for those who have access in the folder where the file is saved.

    • Viet Minh says:

      I have shared a workbook to five user, lead to my workbook become very slow when save, open and any filter. Why? Please help me solve the problem.

  27. Matt says:

    Hi, sorry if this has already been asked...

    I've created a shared file for my team to use when forecasting performance for the rest of the year. Each team member have their own forecast input and forecast summary tabs, with all tabs having the same layout.

    The calculations all work fine, the problem is with the layout and format of what they see. I spend time each month adjusting the layout of the input tabs so they only see the cells they need to update - this involves, changing the groups of columns/rows to hiding/unhiding data, filtering data tables to the correct month(s), etc. However despite how the screens look when I save the file and pass it to them, when my team load the file they are presented with a different view to the one I've saved - cause by different cells/rows/columns showing on their screen to mine. This even happens if we open the same file at the same time.

    How can I 'force' Excel to open and show the same cells on their computers as I see on mine? FYI - I'm using Excel 2013 and they are all still on 2007, could this be the reason they receive different views?


  28. Muhammad Shahab says:

    I would like to have exclusive right to edit the workbook. But unfortunately I lost that right when I got another computer. How can I do that.

  29. Kaitlynn Conrow says:

    So you are given the option to "open in excel", which allows for more of the useful functions to be utilized. When multiple people are working on the excel sheet at one time only one of them can open it in excel and when other group members try to they are told that it is locked. We can all work on it simultaneously in the online version, but again this limits the functionality of our excel workbook. Please let me know if there is a way to fix this issue so multiple people can edit the document in excel at once.

  30. Lyndall says:

    Hi, how do you allow a xls file to have one master user and be able to distribute it as 'read only' to others without it being 'read only' when the master user goes in to modify it later?? Can it be done??

  31. Sarah Davies says:

    I have a shared excel, mainly for production use, 2 of us use multiple times during the day. With 2-3 others a couple of times a week. Issue we have is it doesnt like us being able to work on it and make changes at the same time, so for safety reasons we only allow 1 person working on it at the same time. Our biggest problem is, when 1 person is working on it and walks away, the other needs to access it, is there a way you can boot the other person out and save their changes, in order to do your work?

    • Mary says:

      I have the same issue! We have five people accessing same Excel spreadsheet and do not want to open it up to multiple users making edits simultaneously. If it has been idle for a period, say ten minutes, can that user be booted out?

  32. Varun Sharma says:

    How many people/users can work on a shared work book?

  33. Nandhu says:

    If I have save as the shared workbook on the another places and deleted it, then what will happen. Is the original file will still there in the older place or that also will deleted?

  34. Sandy VonMoss says:

    In Excel, how can I make my "Save" icon only be "Save" and not "Save this document and refresh it with updates made by other authors."

  35. jack says:

    the Unshare button on the review tab is greyed out and i wanted to know how to un grey it out so i can click on it. how can i get this to work so i can share my document

  36. Mary says:

    I have the same issue! We have five people accessing same Excel spreadsheet and do not want to open it up to multiple users making edits simultaneously. If it has been idle for a period, say ten minutes, can that user be booted out?

  37. Mayur says:

    can i share from my local pc over network?

  38. Juan says:

    I am developing a workbook that has seven individual tabs belonging to seven individual people. I want to share it to the group via email. I want them to be able to edit their own tab but not be able to view the other tabs until they make changes to their own. And once they make changes to their own tab, it's final. They cannot go back in and make changes. Thank you in advance.

  39. Gaz says:

    Hi, does this share option have a privacy facility? For example: I would like to be able to share a simple spreadsheet with a list of days work available with multiple users so they can input their own availability, but without other employees being able to see what they have entered. In effect giving each user individual columns only that they can see and edit alongside the original list of dates I have entered. Ultimately providing me with a list of who is available all in one place? Thanks in advance

  40. david says:

    how do i change the title of an editable link that im sharing through an email? i want the link to say what it is and not all random letters and numbers in the email? Ive done it before but cant remember how to change it.

  41. Izetta says:

    human hair wigs
    When I look at the picture now, I think, She has no idea what's coming.
    I also look at her fondly, like a sister, but someone who
    is not me. I know other people look back and mourn that
    person they were before. A signalized ramp is to be added for access to County Routes 516
    and 527. Subsequently, County Route 516's intersection with Old Matawan Road
    is to be relocated. The project would cost
    over $28 million and was slated to begin in 2009
    and to end in 2010.

    hair extensions I actively sneak aboard enemy Galleons, usually by staying on the rope ladder for ten minutes at a time until my opening
    and will hide in the ship. The pirate I'm in cahoots with follows a distance away in our sloop.
    As the hostile Galleon crew loads up the ship
    with booty, I sneak around, drop it off in the water behind and my partner picks the
    floating treasure up, turns it in.. hair extensions

    human hair wigs Playing baseball near Hollywood proved fortunate, as he was
    spotted by an MGM casting director and subsequently signed
    for the 1952 Tracy Hepburn film Pat and Mike.
    He portrayed Sylvester J. Superman, a lanky rustic yokel who shared
    the same name as the title character of the series.Connors was cast as Lou Brissie, a former professional baseball
    player wounded during World War II, in the 1956 episode "The Comeback" of the religion anthology
    series Crossroads. human hair wigs

    hair extensions The Pee wee Herman character was developed by Reubens into a live stage show entitled The Pee
    wee Herman Show in 1980. It featured many characters that would go on to
    appear in Playhouse, including Captain Carl, the Genie, Miss Yvonne, the Pterodactyl and Clocky.
    While enjoying continuous popularity with the show, Reubens teamed with young director Tim Burton in 1985 to make the
    comedy film Pee wee's Big Adventure. hair extensions

    human hair wigs Romona Keveza uses silk taffeta here to make this dress, stylish, comfortable, and very chic.

    Silk taffeta is a really smart decision for anyone, who wants
    a fabric that will last throughout the wedding event without getting overly stressed from wear.
    Moreover, it is not only the choice of Ramona's fabric here, which
    makes it so perfect for a thin bride, it is also her excellent choice to use delicate, re embroidered, Alencon lace overlay.
    human hair wigs

    wigs for women Whichever distro we chose was likely
    to be unpopular with someone. I think it would have
    perhaps been more in line with the video to choose Puppy or some other slim distro.
    I think I defaulted to Ubuntu because my current machine is the
    Sputnik, but I agree perhaps more thought should have been put into it..
    wigs for women

    hair extensions Picturedabove is a diagram I drew before I started choosing which theme.
    Pre planning and visualizing your costume will help greatly.
    Photos shown above.7. Levett, for instance, who had previously managed some German bread interests for Oswald,
    now planted cornfields in Bengal.When Oswald needed Chinese
    labourers, for his own estates, he approached John Levett in Calcutta, who employed
    Chinese labourers in his Bengal operations growing arrack for his distilleries.
    The relationships between the various associates in Oswald's extended trading empire grew: John Levett was corresponding
    with Oswald about the marble chimney piece
    sculptures that his brother Francis Levett was purchasing on Oswald's behalf in Livorno, Italy,
    where Francis was then living as an English merchant.[16] Oswald was particularly close to the Levett and Thoroton families, as well as to the Duke of Rutland.[17]In letters to
    British General and East Florida Governor James Grant, Oswald confided
    that at one dinner of investors in East Florida and Nova Scotia that "Oswald had been dining at the Duke's with Lord Granby, Mr. Thoroton, and others where jokes passed round the table about the many settlements that would be needed to satisfy Mr. hair extensions

    wigs online We do not police topics that people want to talk about as long as they are related to the trans experience. That includes sexual abuse, HRT, or surgeries. It sounds like you need to find a better group. When it comes to 1), it rubs people the wrong way because he will tell you straight up that your grappling like an idiot (if you are). If you are a spaz, he will just bluntly say it. But, it usually comes with some advice on how to change and improve it (which is what gets very overlooked IMO). wigs online

    human hair wigs Barbie's PendantBarbie's "pectoral" (from Latin pectus, chest/breastbone) ornament is obviously based onthis pectoral of King Tut. In fact, he had multiple necklaces featuring this design, which showcases the hieroglyphs of another of his four royal names. From bottom to top, bowl scarab sun reads Neb Kheper Re, "[the supreme god] Re, Lord
    of Becoming.". human hair wigs

    cheap wigs Its not about down votes, its about valid points. Which whoever voted and ran and didnt explain why is dumb as hell. Thanks gn. Well to start with, at least attempt to verbally deescalate the situation. Then I would expect them to use the minimum amount of force necessary to regain control. And I would expect them to use a strategy that did not just accept the collateral damage of gassing other kids who were sitting compliant in their cells.. cheap wigs

    wigs for women "These artistic and original hairstyles can be achieved
    by spending hours at the hairdresser. "If you crave a short style that has workable volume like Charlize Theron's Oscar worthy pixie, you should try Power byRaquel Welch wigs. This choppy, layered pixie can be teased up for some volume or combed flat for a sleek, sexy look. wigs for women

    clip in extensions She ended up crying the whole day. The entire school couldn stand the guy anyway, and everyone knew who it was because he had a HUGE fuck off tribal tattoo on his forearm that he didn bother to cover. I guess he was afraid more people would recognize his penis than his HUGE fuck off tribal tattoo. clip in extensions

    lace front wigs Ticketed seats around the bar were at ground level so it must have been annoying to have spent that much and have people reaching between/over you to order drinks all night. The bar rail wristbands had a drink ticket attached they could use for one free drink (booze ok). I left the search criteria wide open as possible.. lace front wigs

    human hair wigs I readto my children from the time they were born. I love books, and the sweet moments they provide. Always before bed, every day, and sometimes even in the middle of the night, we read. The only railways in 1864 in Denmark north of the Konge were a line in Sjlland from Copenhagen to Korsr, and one in northern Jutland from rhus to the northwest. Any reinforcements for the Danevirke from Copenhagen would have gone by rail to Korsr and thence by ship to Flensburg, taking two or three days, if not hindered by storm or sea ice. There was a good railway system in the duchies, but not further north than Flensburg and Husum.. human hair wigs

    cheap wigs More people around me are ridiculously popular on Insta and get to fund their lifestyle. A friend of mine has men who fund her lavish lifestyle just because. I somehow ended up in that world too but I don't get paid, do get free things now and then. cheap wigs

    lace front wigs MONET a lot of people said she faded into the background this week, but i thought her performance was great, and she's still getting the narrator edit. I think where she's going to trip up is another sewing challenge; spongegate was fun and all, but the level of jinkx monsoon's delusion was definitely there to foreshadow as well as entertain. She's entertaining to watch but in a self aware way that doesn't really hurt other people, and i appreciate that in a competitor lace front wigs.

  42. Kim A Feyerabend says:

    I want to share one workbook with multiple people. Each person will have their own tab. Can make each tab to be seen and edited only by myself and the other person?

  43. Aisha says:

    I downloaded an excel file to my flash drive and tried to rename it but it still comes up with the "[shared]" file name how do I go about editing it?

  44. ky says:

    the workbook is courrenty open 256 users. maximum of 256 users can have share workbook open at the time. the workbook will be opend read only. you can try again later when you one of more users have clothed the workbook.

  45. Mona says:

    I am sharing spreadsheet with 3 other co-workers. 10 Columns on far left and top 3 rows are frozen and some columns are hidden (previous weeks' schedule). But sometimes when someone opens the spreadsheet either none of the columns are hidden or the frozen columns are hidden as well. Any idea how to fix?

  46. Francine Ryan says:

    I would like information about excel document conversion.

  47. Rob says:

    This may be lengthy and may not be able to be done, but hopefully.
    Little background. I have a workbook with 16 tabs, 1 for each sales person we have.
    1. I want to share this with everyong but want them to only have access to their tab.
    2. In that tab I have columns up to something like BT and want them to see the fist 10 columns and then not see columns 11- BR. After that I want them to be able to see columns and edit cells from BU to xzy.
    3. In the cells they can have checkboxes to click to tasks done and it will put a date in a hidden column to task tracking.
    4. The task tracking will be done on dates provided by them on completetion of review dates for project sales so at least once a month they will need to be having conversations with their customers.
    5. With this data on another tab I will want to set up alerts based on dates coming up for them to be notified that they have a review to be done. This will be a tab that will send out automated emails and also a places for the sales manager and GM to review timely repoting of reviews along with a tally of where we stand.

    I need an excal angel right now.


    • Rob says:

      Forgot to mention, when I open this spreadsheet I would like full access to it without and hidden or locked cells.

      Different permissions for different people?

  48. Niels Reinbergen says:

    Issue is that we have a little club, with one person doing the bookkeeping in excel on his pc. We like two other members having the possibility to work on the original excel file. They are the backup friends. There's no network. Hence storage in the cloud. All three to work from own pc, with their own login procedure. Do we need to install MS Office then with multi user licence? Anything else we must take into account?
    Thanks for your help.

  49. Ellen says:

    The instructions don't address Excel 2007. Can I share one of those files with a One Drive account?

  50. Aklilu Demeke says:

    It says enable or disable macrons

  51. Leandro says:

    HOw can multiple users edit an excel with password?

    My colleague tried to open the same file and it didn´t ask the password. Jst ask to open as a read only or be advised when the file is closed by the other user.

  52. Jessica says:

    Hi, Thanks for sharing this information very helpful, Every time I unshared the excel workbook it gets locked. then I have to save it again. Why is this happening?

  53. Dana Pinkert says:

    Is is possible to share worksheet and have certain users sign off by entering initials or something similiar and not allow other users to make changes to those cells.

  54. Tapio Hellman says:

    How do you protect cells for certain AD members and share Excel O365 worksheets nowadays? I have applied Excel > Review > Allow Edit Ranges > New > RangeName > Cells > Permissions... > Add... > My AD User > Check Names > OK > Edit range without a password: Allow > OK > OK > OK, then protected the sheet by Review > Protect Sheet > Protect worksheet and contents of locked cells, Select locked cells, Select unlocked cells > OK, then shared the file by File > Share > Share with People > Share with People > Link settings. If I share the link for a) Anyone with the link, Allow editing is not available; b) People in My AD with the link > Allow editing, anyone in My AD can edit all cells even if they are not allowed to do so and the sheet is protected OR some people can edit all the cells but some are informed that the file is not editable; c) People with existing access, Allow editing is missing; d) Specific people > Allow editing, anyone in My AD can edit all cells even if they are not allowed to do so and the sheet is protected; So, what is the correct way to share a multi-user Excel sheet for several AD users so that each of them are able to enter data only in the cells that they are supposed to?

  55. AKK says:

    Thank you so much. This worked perfectly. I managed to prove our IT Dept. wrong. They said this type of sharing was not possible in excel.

  56. B. Hoskins says:

    My workplace has about 20 peers all working and updating different areas of a sheet together and we recently converted over to Google Sheets. It's so much smoother. I had no idea how many issues we were working through until they weren't there anymore.

Post a comment

Thank you for your comment! When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to your query. We cannot guarantee that we will answer every question, but we'll do our best :)