Firstly close this opened Share Workbook dialog box. Then most probably the chances may be that your shared workbook protection is left on. If in case the checkbox grayed out or you are unable to uncheck it. If there is some other user also attached then disconnect all of them. In the “Who has this workbook open now” box, make sure only your name is listed here. If you agree to this statement, then click Yes, otherwise No. You have to clear the checkbox present besides this option and then, and click OK button.Ĭlicking the OK option will throw an alert, with the message “you are about to remove the file from shared use and erase the change History”. You can see there is an editing tab having the following option “ Allow changes by more than one user at the same time…”. This will open the Share Workbook dialog box. In your Excel workbook click the review After then go to the Changes group and chose the share workbook icon. Method 1: Enable “Unshare” From The Share Option So if the option of unshare workbook greyed out in Excel or if it’s not working then you can try some other way. You can turn off sharing of Excel workbook by various methods. Preview the repaired files and click Save File to save the files at desired location. Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process. Download Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. 
NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved.
OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 kommentar(er)
