Disk Cleaner can Speed Up Your Windows: 9월 2016

2016년 9월 29일 목요일

Do I need to use a VLOOKUP or IF Statement?

I have a column of special ID numbers. I also have a large data dump and need to know if the ID numbers in the data dump are special or not. How can I do this?

Any insight will be greatly appreciated. Thanks!!!

Anwsers to the Problem Do I need to use a VLOOKUP or IF Statement?

Download SmartPCFixer to Fix It (Free)

Assuming your special names are in A1:A10 and your data dump names are in B1:B100, use the following formula in cell C1 and copy down as far as you data dump is.

=IF(COUNTIF($B$1:$B$100,A1)>0,"Y","N")

This will return a "Y" if a value in column A exists in B1:B100.
Adjust the ranges to reflect your actual data.

Boot in Safe Mode:

Open Run command as previously described
Type MSConfig
Click on Boot tab
Tick Safe boot in Boot option
Select Network
Click Apply and OK
Reboot your system

Your system will boot in Safe mode with Networking. You may now try and open Windows Store and should not see any errors.

document.xlsx is locked for editing by 'username'.

hi all, its been annoying for us.
a document on the server 2008 is saying document.xlsx is locked for editing by 'user1'. click notify or read only.
when the user already closed the document.
the strange thing is, when the user1 closes, user2 can open
but when user3 tries to open it says it locked by user1.
but i can see on the server that user2 has opened it (eve he closed it too).
so whoever wants to use it, they call user1 to ask her to close excel.
she is very frustrated, i must fix this.
please help.
if i go on the server, manage open files, force the user2 to close, it can be opened by user3.
thats a workaround for now, but i really need to fix this.
forgot to say that the user1 is always the same user.
user2 & user3 could be anyone in the company.

Keys to the Problem document.xlsx is locked for editing by 'username'.

Download SmartPCFixer for Free Now

Click on the Review button on Excel > share work book > ensure that the option ‘ Allow changes to be made by more than one user at the same time is checked.

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.

DNS problem with false IP address on computer file discovered. HELP

installed a new Virus program (switched Kaspery to Norton) and DNS could not be verified or recognized. When IP address was finally found (ARIN) it was not pertaining to my machine but to another in another city, another place. How can this be?- is
this a hijacking that my spyprogramming is just not able to clear out, a bot, or a virus or is there another explanation that maybe the FBI cyber crimes unit should enlighten us about? have you ever heard of such a thing from a MS product?

Anwsers to the Problem DNS problem with false IP address on computer file discovered. HELP

Download Error Fixer (Free)

Your post is in the forum for persons needing assistance with the Microsoft Security Essentials (MSE) antimalware program.

Since your "glitch" appeared after you uninstalled Kaspersky and installed Norton, suggest your question should be addressed by Norton Support.

You might try: http://community.norton.com/

You also might find some helpful information by reading the answer of Kosh Vorlon in the following thread:

http://answers.microsoft.com/en-us/protect/forum/protect_scanning/identifying-computer-ip-addresses/0b3d14f6-979c-4053-a74b-845f2e8b0d15

Make Sure that your Computer Meets the System Requirements

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
16 GB available hard disk space (32-bit) or 20 GB (64-bit)

This error can be due to some configuration requirements for you system. If your computer hardware is not up to par, then make sure you upgrade where necessary before continuing.

Another Safe way to Repair the Problem: DNS problem with false IP address on computer file discovered. HELP:

How to Fix DNS problem with false IP address on computer file discovered. HELP with SmartPCFixer?

1. Download Error Fixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed

[Anwsered] Downloading from the Internet

Downloading from the Internet

Purchased this computer in 1/2009. Had some issues going from XP to Vista but that was expected. A couple days ago, I attempted to download iTunes (version 8.2.1) which I've never had in any prior version. It would go through the set-up process fine but
once it started to install the program, I would never see any progression in the status completion bar.
Determined that I needed the 64-bit version and attempted to download it. Same problem occurred as stated above.
Thought that maybe my security software (McAfee) was the issue so I minimized all protection. Attempted to download iTunes 64-bit and had the same problem as stated above.
Located within McAfee an option called "Service Technician" which was to analyze any problems within it. Tried to download it but had the same problem as stated above. The set-up came through fine but once the installation began, I had no progress shown
on the status completion bar. Appears to be timing out.
Went to some Vista sites for problems. Found a MicroSoft link that would update and/or patch the Vista problems that were known. I selected this option. Set-up process went fine but when it came to the installation process, I had no progress showing on
the status completion bar. This also timed out.
Same issue wherever I go. It appears that I can't download properly from the internet. Is this a "driver(s)" issue? Can you assist and/or direct me on how to overcome this issue?
I'm using "Windows Vista Home Premium" with a 64-bit OS.

Thanks,

Anwsers to the Problem Downloading from the Internet

Download Error Fixer (Free)

Hi GLMinCa,

Thank you for posting on the forums.

Sounds like you might have a corrupted profile. Please follow the steps in this article on how to
Fix a corrupted user profile

To create a new user profile

To create a new profile, you must first create a new user account.
When the account is created, a profile will also be created.

1.

Open User Accounts by clicking the Start button , clicking
Control Panel, clicking User Accounts and Family Safety (or clicking
User Accounts, if you are connected to a network domain), and then clicking
User Accounts.

2.

Click Manage another account.
If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

3.

Click Create a new account.

4.

Type the name you want to give the user account, click an account type, and then click
Create Account.

Now setup your e-mail in windows mail and see if you’re still having the same issue.
If not, please follow these instructions to move copy your files to your new profile.

To copy files to the new user profile

After you create the profile, you can copy the files from the existing profile.
You must have at least three user accounts on the computer to complete these steps, including the new account you just created.

1.

Log on as a user other than the new user you just created or the user that you want to copy files from.

2.

Open Documents by clicking the Start button , and then clicking
Documents.

3.

Click the Tools menu, and then click Folder Options.
If you don't see the Tools menu, press ALT.

4.

Click the View tab, click Show hidden files and folders, clear the
Hide protected operating system files check box, and then click
OK.

5.

Locate the C:\Users\Old_Username folder, where C is the drive that Windows is installed, and
Old_Username is the name of the profile you want to copy files from.

6.

Select all of the files and folders in this folder, except the following files:

•

Ntuser.dat

•

Ntuser.dat.log

•

Ntuser.ini

7.

Click the Edit menu, and then click Copy.
If you don't see the Edit menu, press ALT.

8.

Locate the C:\Users\New_Username folder, where C is the drive that Windows is installed, and
New_Username is the name of the new user profile you created.

9.

Click the Edit menu, and then click Paste.
If you don't see the Edit menu, press ALT.

10.

Log off, and then log back on as the new user.
If you have e-mail messages in an e-mail program, such as Windows Mail, you must import your e-mail messages and addresses to the new user profile before you delete the old profile.
If everything is working properly, you can delete the old profile.

If the steps above do not fix the problem, you should contact your customer support provider for assistance.
To find additional information about customer support options that apply to this computer, click the
Start button , click Help and Support, and then click the
Ask someone or expand your search link at the bottom of the Help window.

Hope that will fix it for you, please post back and let us know.

JohnD
Microsoft Answers Support Engineer
Visit our
Microsoft Answers Feedback Forum and let us know what you think.

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Dot net frame work 2.0 will not install says its not supported

hi

Iam using window 7 Home Basic i cant install Dot Net Framework 2.0.
error message is this product is not supported on a 64-bit os.
How can i install it ?

Thanks

Sreejith

Keys to the Problem Dot net frame work 2.0 will not install says its not supported

Download SmartPCFixer to Fix It (Free)

This particular error can easily be resolved with a few simple steps. However, if you are not confident in your ability to use the methods below or they do not fully remove the issue on your computer, you may want to seek the assistance of a qualified repair technician who is well versed in fixing Dot net frame work 2.0 will not install says its not supported.

Back-up the Registry of your operating system.
Find the Registry Key: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\OSUpgrade]
Note: this Registry Key should already exist, if it does not exist, create it.
Create a brand new DWORD Value that is named AllowOsUpdate
Set the Value to 0x00000001.
Close and reopen your Control Panel.
Restart the Microsoft Windows.

Another Safe way to Repair the Problem: Dot net frame work 2.0 will not install says its not supported:

How to Fix Dot net frame work 2.0 will not install says its not supported with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.

Solution to Error: Document Properties / Advanced Properties / Custom tab - uses?

Document Properties / Advanced Properties / Custom tab - uses?

1.
Open a document.

Office Button

Prepare

Properties

The Document Information Panel opens

2.
In the Document Information Panel towards the top left hand corner there is a drop down field called:-

Document Properties

I click on the drop down arrow then click on:-

Advance Properties .
.
.

A new window opens.

3.
In that new window there is a tab called:-

Custom

What are the settings in this Custom tab used for?

Thanks in advance for any replies.

Keys to the Problem Document Properties / Advanced Properties / Custom tab - uses?

Download Error Fixer for Free Now

Word comes with a series of predefined properties such as Checked By, Client etc., and you can create your own properties.
You can use these to store information about the document that doesn't fit in the properties provided in the Summary tab of the Document Properties dialog.
You can refer to the value of a property anywhere in your document by inserting a DOCPROPERTY field.

For example, let's say you create documents for a company with several departments.
You can enter the name of the relevant department in the Department property, then press Enter or click
Modify.
To insert the name of the department into the document, press Ctrl+F9 to insert field brackets (or use your custom button).
Type DOCPROPERTY "Department" between the brackets, then press F9 to hide the field code and to update the result.
To change the department throughout the document, you only need to modify the value of Department in the Custom tab of the Document Properties dialog, then update all fields in the document (for example by print previewing it).

If you need a property that hasn't been predefined, you can create it yourself:
Type a name in the Name box, e.g.
Report Year.
Select a type (Text, Date, Number or Yes/No) from the Type dropdown, e.g.

Number.
Enter a value in the Value box, e.g.
2013.
Click Add.
The property has been added to this document, and it will be saved with the document.
You can use it in a DOCPROPERTY field just like the predefined properties.

Document properties can be retrieved and set in VBA through the BuiltinDocumentProperties and CustomDocumentProperties collections of the Document object:

MsgBox ActiveDocument.CustomDocumentProperties("Report Year").Value

Check Windows System Requirements

This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
16 GB available hard disk space (32-bit) or 20 GB (64-bit)

do i need to fix registry errors, file ext. shared dll, etc

do oi need to fix registry errors, file extention erros, shared dll, etc,

Keys to the Problem do i need to fix registry errors, file ext. shared dll, etc

Download Error Fixer (Free)

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.

do i have a virus - When I open Internet Explorer it loads a blank page that says about:Blank

i'm having a problem with logging on.
when i press the explorer logo to excess the internet it goes to a blank page with about blank in the box, so i have to go to my recent history to find a homepage when it do that before it went right to my homepage
does that mean that my computer has been infected with a registry virus or infected period my virus protection shows that i'm protected and didn't have this problem in the begining why now

Keys to the Problem do i have a virus - When I open Internet Explorer it loads a blank page that says about:Blank

Download Error Fixer (Free)

Hi,
· Was there any changes made prior to this issue?
Step 1: Check if the home page is set.
http://windows.microsoft.com/en-US/windows-vista/Change-your-Internet-Explorer-home-page
Step 2: If you suspect that the computer is infected, then run a virus scan
You can do an online scan by clicking on the link http://onecare.live.com/site/en-us/default.htm and Clicking on the Full Service scan and accept
the Agreement.
Refer to “How can I tell if my computer has a virus?” : http://windows.microsoft.com/en-US/windows-vista/How-can-I-tell-if-my-computer-has-a-virus
Diana
Microsoft Answers Support Engineer
Visit our Microsoft Answers Feedback Forum and let us know what you think.

If this post helps to resolve your issue, please click the "Mark as Answer" or "Helpful" button at the top of this message.
By marking a post as Answered, or Helpful you help others find the answer faster.

Run CHKDSK

Go to the Start button.
In the Search box, type "cmd" (without quotes) and press Enter.
At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
Restart your computer.

Downloaded hotfix kb925681 but dont know which folder to extract and how to instal it?

when i connect my n8 through ovi suit in window7 it says download hotfix,i have downloaded it but dont know which folder to extract and how to instal it?

Keys to the Problem Downloaded hotfix kb925681 but dont know which folder to extract and how to instal it?

Download Error Fixer for Free Now

http://support.microsoft.com/kb/925681

How to Avoid Downloading Malware

Where are you getting the download?

There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.

Cancel or deny any automatic download

Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.

Avoid advertisements on download pages

To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.

2016년 9월 29일 목요일

Do I need to use a VLOOKUP or IF Statement?

Anwsers to the Problem Do I need to use a VLOOKUP or IF Statement?

Boot in Safe Mode:

Recommended Method to Fix the Problem: Do I need to use a VLOOKUP or IF Statement?:

How to Fix Do I need to use a VLOOKUP or IF Statement? with SmartPCFixer?

document.xlsx is locked for editing by 'username'.

Keys to the Problem document.xlsx is locked for editing by 'username'.

Recommended Method to Fix the Problem: document.xlsx is locked for editing by 'username'.:

How to Fix document.xlsx is locked for editing by 'username'. with SmartPCFixer?

DNS problem with false IP address on computer file discovered. HELP

Anwsers to the Problem DNS problem with false IP address on computer file discovered. HELP

Make Sure that your Computer Meets the System Requirements

Another Safe way to Repair the Problem: DNS problem with false IP address on computer file discovered. HELP:

How to Fix DNS problem with false IP address on computer file discovered. HELP with SmartPCFixer?

Downloading from the Internet

Anwsers to the Problem Downloading from the Internet

Recommended Method to Repair the Problem: Downloading from the Internet:

How to Fix Downloading from the Internet with SmartPCFixer?

Dot net frame work 2.0 will not install says its not supported

Keys to the Problem Dot net frame work 2.0 will not install says its not supported

Another Safe way to Repair the Problem: Dot net frame work 2.0 will not install says its not supported:

How to Fix Dot net frame work 2.0 will not install says its not supported with SmartPCFixer?

Document Properties / Advanced Properties / Custom tab - uses?

Keys to the Problem Document Properties / Advanced Properties / Custom tab - uses?

Check Windows System Requirements

Recommended Method to Fix the Problem: Document Properties / Advanced Properties / Custom tab - uses?:

How to Fix Document Properties / Advanced Properties / Custom tab - uses? with SmartPCFixer?

do i need to fix registry errors, file ext. shared dll, etc

Keys to the Problem do i need to fix registry errors, file ext. shared dll, etc

Recommended Method to Repair the Problem: do i need to fix registry errors, file ext. shared dll, etc:

How to Fix do i need to fix registry errors, file ext. shared dll, etc with SmartPCFixer?

do i have a virus - When I open Internet Explorer it loads a blank page that says about:Blank

Keys to the Problem do i have a virus - When I open Internet Explorer it loads a blank page that says about:Blank

Recommended Method to Repair the Problem: do i have a virus - When I open Internet Explorer it loads a blank page that says about:Blank:

How to Fix do i have a virus - When I open Internet Explorer it loads a blank page that says about:Blank with SmartPCFixer?

Downloaded hotfix kb925681 but dont know which folder to extract and how to instal it?

Keys to the Problem Downloaded hotfix kb925681 but dont know which folder to extract and how to instal it?

How to Avoid Downloading Malware

Recommended Method to Repair the Problem: Downloaded hotfix kb925681 but dont know which folder to extract and how to instal it?:

How to Fix Downloaded hotfix kb925681 but dont know which folder to extract and how to instal it? with SmartPCFixer?