A required privilege is not held by the client ,can not copy data to a drive,WINDOWS 8 - Error 0x80070522 solved

So faced this issue on windows 8

this is how it got solved for me,I tried to take ownership and use icacls(see http://wowmoron.blogspot.in/2014/02/access-denied-error-in-windows-8.html),but it didn't work,I wasn't surprised because that drive contained some os files from previous installation,

Then I tried

 Press Windows key + X, select Run
 Type “msconfig” and press enter
 Select the tools tab
 Select “change UAC settings” and click launch
 Select the UAC control to “never notify me”

but it didn't work for me

so then I tried

 Run->secpol.msc
 Local Policies->Security Options.
 Set "User Account Control: Run all administrators in Admin Approval Mode" to Disable.
 Restart the PC ! and voila I can even copy to c drive on my windows 8

just for the information it's 4.22 in the night,geek's night out eh!!!
 

Remove duplicate entity from a column

Select the column by clicking top of the column, then go to data-validation, select custom and type the

custom rule =COUNTIF(A:A,A1)=1

Access Denied error in Windows 8

after long time posting again..

I moved to windows 8,have some files from windows xp,now can not access them,access denied error

Here is how to take ownership of those files in windows 8(gui method did not work surprisingly)

a) Press “Windows Key + Q” to open Charms Bar.
b) Type “cmd” without quotes in the search box.
c) On the left pane, right click on the “cmd” option and select “Run as Administrator”.
d) Type "TAKEOWN /F c:\windows\winsxs /A /R" without quotes press enter. 
Note: Here c:\windows\winsxs is the file location. 
e) Type “ICACLS c:\windows\winsxs /grant:r Everyone:F /T” without quotes and press enter. 
Note: Here c:\windows\winsxs is the file location

Now even after doing that and even after getting the success of the commands I was still getting  the access denied,so I tried to to take ownership of the whole folder and enabled inheritance and it worked unlike before.

Here is the the link that helped me.

http://answers.microsoft.com/en-us/windows/forum/windows_8-security/you-do-not-have-permission-to-view-this-objects/5939dbf4-ca81-4f14-b455-ede115af924e 

Conditional formatting based on numerical values using different color

Right click on a column containing 10 ,20 and 30 and format cells,click custom and type

[BLUE][=>30]00;[MAGENTA][=>20]00;[green]00

and you are done.

you can not change the color of any cell using traditional method

Java not working in Internet Explorer after installing java on Windows 8 solved

I have faced this error,fortunately found the solve.

Reinstall Java using offline version.(just the jre in the second time works for me)

    Go to the Windows offline page

    On the download page, click Agree and Start Free Java Download

    If you've already installed the version, you will see a message, This software has already been installed on your computer. Would you like to reinstall it?

    Click Yes and reinstall,and you are done.

source:https://java.com/en/download/help/ie_tips.xml