Skip to main content

Excel Unprotect Share Workbook

Earlier I wrote about "How to Unshared Excel Workbook" but
in some cases I found out the the "Allow changes by more than one user..." checkbox is DISABLED.

This occurs if the workbook was being protected., to remove the Shared Protection  follow the below step by step procedure

1. Open Excel file

2. Click "Unprotect and Share Workbook"
    - On Excel 2003 or earlier
       * Tools -> Protection -> Unprotect and Share Workbook
  
     - On Excel 2007 or higher
       * Review Tab -> Unprotect and Share Workbook

3. If the password was set, it will require you to enter on the popup window

Comments

Post a Comment

Popular posts from this blog

Bundy Clock Quick Setup Manual for IWATA TIME RECORDER CW-1A, CW-2A, CW-2SA

Recently, I bought IWATA bundy clock for our office and I'm happy because there is a Quick Setup Manual included in the package which is hard for me to find/download from the internet. Then I realized that it might be useful in the future so I decided to upload the manual here. Thanks,
2 comments
Read more

Bundy Clock Set Time (IWATA CW-1A)

if the time is advance    * Press "HO" button once to stop the timer    * Press "HO" button again to start the timer if the time is late    * Press "SY" to add 1 minute UPDATE: I have already a copy of Quick Setup Manual for IWATA Bundy Clock. CLICK HERE
2 comments
Read more

SONY Ericsson XPERIA E15i (HARD RESET)

METHOD 1: a. Turn off your phone b. Press and hold LEFT, RIGHT and POWER buttons until the factory reset menu appears c. Select Wipe Data d. Reboot/Restart your phone. METHOD 2: (proven effective) a. Download SONY PC COMPANION 2.1 here b. Install it into your PC and run the program c. On "SUPPORT ZONE" panel, click "Start" d. On  "Phone / Tablet Software update", click "Start" e. Click "Repair my Phone / Tablet" f.  Click "Continue" g. Tick the box "I understand.." and click "Next" h. Tick the box "I understood..." and click "Continue" i. Tick the box on "Battery Level Info" and click "Next" j. Select you phone model in the selection and click "Next" h. Connect you phone to PC       h-1. Turn off you phone and wait for 5 seconds      h-2.  Connect your Phone to the PC while pressing the Back Button (Left Button) using USB Cord. i. F...
2 comments
Read more