Marka nuqulka ugu dambeeya ee buuggaaga shaqada ee Excel 2016 uu dhammaado waxaa laga yaabaa inaad rabto inaad joojiso ama aad damiso wadaagista buugga shaqada ee Excel^{( stop or turn off the workbook sharing in Excel)} si aad uga hortagto isbeddel kasta oo aan loo baahnayn. Si kastaba ha ahaatee, ka hor inta aanad joojin wadaagista buug-hawleed, hubi in dhammaan isbeddelada ama ku-darka la habeeyey sababtoo ah wixii isbeddel ah ee aan la kaydin waa la lumin doonaa. Taariikhda Beddelka^{(Change history)} sidoo kale waa la tirtiri doonaa, iyadoo garab socota. Waa kan sida loo sameeyo.

Sideed u damisaa wadaagista buuga shaqada ee Excel

Marka hore, nuqul ka samee macluumaadka taariikhda isbeddelka. Taas awgeed, dhagsii 'Raadi isbeddelada' ikhtiyaarka ka muuqda hoosta kooxda Isbedelka^{(Changes Group)} ee tab^(Review) .

Marka xigta, ku dhufo badhanka Isbedelka Highlight . ^{(Highlight Changes)}Liiska marka, dooro Dhammaan oo ka saar sanduuqyada hubinta ee Who and Where .

Hadda, dooro liiska^(List) isbedelaya sanduuqa calaamadaynta xaashida cusub, ka dibna riix OK. Hadda, samee waxyaabaha soo socda

Ku koobbi taariikhda buug kale oo shaqo. Dooro unugyada aad rabto inaad nuqul ka sameyso, u beddel buug kale oo shaqo, oo dhig xogta la koobiyay. Intaa ka dib^(Thereafter) , gudaha buuga shaqada ee la wadaago, u gudub tabka dib u eegista^(Review) , iyo hoosta kooxda Beddelka^(Changes) , dhagsii Share Buuga Shaqada^{(Share Workbook)} .

Nadiifi ikhtiyaarka 'Oggolow isbeddelada in ka badan hal isticmaale isku mar' Tani waxay sidoo kale u oggolaaneysaa sanduuqa hubinta isku-darka buugga shaqada. Sababaha qaar, haddii aad aragto in sanduuqa jeeggu aanu muuqan, ilaali buugga shaqada. Hadda, si meesha looga saaro ilaalinta buug-hawleedka la wadaago, samee waxa soo socda:

Guji OK^{(Click OK)} si aad u xidhid sanduuqa wada-hadalka Wadaag Workbook .^{(Share Workbook)}

U beddel tab dib u eegista , ee kooxda ^(Review)Isbeddelka^(Changes) , dhagsii Buug-hawleedka La Wadaago Aan Ilaalin^{(Unprotect Shared Workbook)} .

Markaad codsato erayga sirta ah, geli erayga sirta ah oo ku dhufo OK.

Kadibna, tabka dib u eegista , ee kooxda ^(Review)Isbedelka^(Changes) , dhagsii La wadaag Buuga Shaqada^{(Share Workbook)} .

Intaa ka dib, gudaha tafatirka^(Editing) tafatirka, ka nadiifi Allow isbedelada in ka badan hal isticmaale isku mar. Tani waxay sidoo kale u oggolaaneysaa sanduuqa hubinta isku-darka buugga shaqada. Marka ogolaanshahaaga lagu sameeyo isbeddelada ku saabsan saamaynta isticmaalayaasha kale la raadiyo, dhagsii Haa^(Yes) .

That’s it!

How to stop or turn off Workbook Sharing in Excel

Once the final version of your Excel 2016 workbook is complete yoυ might want to stop or turn off the workbook sharing in Excel to avert any unwanted changes. However, before stopping the sharing of a workbook, ensure all the final changes or additions have been accommodated because any unsaved changes will be lost. The Change history will also be deleted, alongside. Here’s how to go about it.

How do you turn off workbook sharing in Excel

First, copy the change history information. For this, click ‘Track changes’ option visible under the Changes Group of Review tab.

Next, hit the Highlight Changes button. In the When list, select All and clear the Who and Where checkboxes.

Now, select the List changes on a new sheet check box, and then click OK. Now, do the following

Copy the history to another workbook. Select the cells that you would want to copy, switch to another workbook, and place the copied data. Thereafter, in the shared workbook, go to the Review tab, and under the Changes group, click Share Workbook.

Clear the ‘Allow changes by more than one user at the same time’ option. This also allows the workbook merging check box. For some reason, if you find the checkbox is not visible, unprotect the workbook. Now, to remove shared workbook protection, do the following:

Click OK to close the Share Workbook dialog box.

Switch to the Review tab, in the Changes group, click Unprotect Shared Workbook.

When prompted for the password, enter the password and hit the OK button.

Then, on the Review tab, in the Changes group, click Share Workbook.

Thereafter, In the Editing tab, clear the Allow changes by more than one user at the same time. This also allows the workbook merging check box. When your permission for making changes about the effects on other users is sought, click Yes.

That’s it!

Related posts

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo dabaqo Mawduucyada oo loo beddelo muuqaalka Buugga Shaqada ee Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah