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,
Post a Comment
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

Windows CE install/update/upgrade/restore

Windows CE install/update/upgrade/restore to factory default. I am having a problem with my wireless book(Netbook or Pocketbook) w/ windows CE 6.0 it was stuck at "Loading Drivers" and nothing happens afterwards. The only solution i can think is to reinstall WinCE 6.0 Prepare:     - 1GB SD Card (Format it as Normal not Quick in FAT)       - Charge the battery of Netbook up to 100% (in my experience, installation may failed if low battery)     - Download  WinCE 6.0 or in http://www.poodwaddle.com/netbook/WinCE.rar      - Extract that file into SD Card root folder (when you open you SD Card in explorer you can see that there is folder named "Script".    - That's all for the preparation Procedure:     1. Turn-off Netbook     2. Insert the SD Card     3. Turn-on netbook     4. It will automatically read and execute the content of the SD Card     5. It will restart automatically and load the software package, and you can see ang windows deskto
1 comment
Read more