How to Fix Excel File Will Not Break Links

There are several user link spreadsheets with the reference link and the value of one Excel file can also be linked with other files. User can also remove or delete those linked files with the Edit dialogue link and Break Link option.

Moreover, some user cannot break all the links from the spreadsheet and can edit the dialogue link. If you cannot break all the edit link dialogue, then you can get help from our blog to fix the issue of excel file will not break links.

How to Edit Links When Edit Links Don’t Break.

Here are four methods to fix Excel file will not break links:-

• Excel worksheet is unprotected
• Delete Named Cell Range
• Clear data validation rules from sheet
• Checking Break link Excel add-in

1) Excel Worksheet Unprotected

Here are the steps on how to unprotected excel worksheet.

1. Choose Excel’s Review option.
2. Hit the Unprotect sheet option.
3. If the sheet has protected with the password, then you need to put your password in the field to open the windows dialogue.
4. Tap on the OK button.
5. The Break link option will maybe not grey out.
6. Choose the data tab.
7. Tap on the Edit Links option.
8. Choose the links listed and click on the break link section.

2) Delete Named Cell Range

Here are the steps on how to delete cell range:-

1. Tap on the formula tab.
2. Hit the Name Manager option.
3. Choose all the name range seen here.
4. Hit the delete button to delete it permanently.
5. Tap on the OK button to confirm the command.
6. Now the complete reference available name listed in the name manager will be deleted.
7. Tap on the close button.

3) Clear Data Validation Rules From Sheet

Here are the steps on how to clear data validation rules from the excel sheet:-

1. Hit the select all button that appears on the top left of the worksheet.
2. Hit the data tab.
3. Hit the data validation option.
4. Choose the data validation button.
5. A dialogue box appears on the screen that asks to clear all.
6. Tap on the OK option on the window.
7. You can also repeat the above steps for other sheets in the spreadsheets.

4) Checking Break Link Excel Add-In

The Break link Tool is a part of the Excel add-in tools which cab provide user to remove all the reference from Microsoft Excel worksheet rapidly. The add-in tools are not available for free, but you can use it one week free as a trial.

To download add-in tools, tap on the download icon in the Break link tool page and install it into your device. If the add-in tools are installed into your computer, then you can see a Break link button on your home tab. To open the tools tap on the ass-in tools icon on your Home tab, and then tap on the Select all button to select all the break tools in the settings. Tapping on the Start option removes all the links available into your Excel sheet.

Deam Jones is a self-professed security expert; he has been making the people aware of the security threats. His passion is to write about Cyber security, cryptography, malware, social engineering, internet and new media. He writes for Norton security products at norton.com/setup.

Firefox is certainly among the most-used web browsers over the globe, but it is not free of errors. One main issue with Firefox is the “Server not found, Firefoxcan’t find the server” error. Users usually suffer from this issue while trying to load the website on Firefox. The issue can hinder your work progress in multiple ways, and if you are facing this problem, then this blog helps you to solve your issue with six methods as given.

• Disable Temporarily Firewall and Anti-virus
• Use Anti-Virus and Malware software to clean your device
• Delete any Proxy Setting in Firefox
• Disable DNS Perfecting
• Disable IPv6 in Firefox
• Delete Cache and Cookies

1) Disable Temporarily Firewall and Anti-Virus

The Window Protector Anti-virus and firewall program on your device blacklists websites and that can be a major reason behind the issue. To resolve this issue, disable the Windows protector antivirus and firewall program on your device temporarily.

2) Use Anti-Virus and Malware Software to Clean Your Device

Several viruses are known to block websites on a system. If your system is showing the Server not found error, then clean up your system from viruses and malware. Thoroughly scan your PC and remove any malicious programs.

3) Delete Any Proxy Setting in Firefox

Proxy setting available on Firefox that can limit access to several websites. Here are the steps to remove the proxy setting:-

1.      Launch the address about:preference in the Firefox search bar.

2.      Visit the Network Settings that appear in the General Settings.

3.      Shift to the radio button to No proxy and tap on the OK button.

4) Disable DNS Perfecting

DNS Perfecting is very useful in speeding up the current website. Although it is also known to occur problems while updating websites and browsers. 

Here are the steps on how to disable DNS perfecting:-

1.      Start about: config in the Firefox search bar.

2.      Choose Accept Risk and Continue.

3.      Find network.dns.disablePrefetch in the search bar.

4.      Here you need to change the preference value from false to True through the toggle option.

5) Disable IPv6 in Firefox

IPv6 feature is default enabled in the Firefox. Although it is also known as a similar problem while attempting to access the website on any browser. 

Here are the steps on how to disable IPv6 in Firefox:-

1.      Start about:config in the Firefox search bar.

2.      Choose Accept the Risk and hit the Continue option.

3.      Find network.dns.disableIPv6 in the search field.

4.      Here you need to use toggle option to change preference value from false to true.

6) Delete Cache and Cookies

The cache and Cookies files contain website information offline and help the user open the website faster. Although, if the cookies or cache file corrupted, then it causes several loading issues. The solution to fix Server not found, Firefox can’t find the Server is deleting cookies and cache files from your Firefox browser application.

Here are the steps on how to delete cache and cookies files from Firefox:-

1.      Open the library option in Firefox and choose History.

2.      Hit Clear Recent History.

3.      Change the time-range and check the box that attaches with the cookies and cache.

4.      Tap on the Clear now to remove all the cache and cookies from the Firefox.

Chloe Decker is a self-professed security expert; she has been making the people aware of the security threats. Her passion is to write about Cyber security, cryptography, malware, social engineering, internet and new media. She writes for Microsoft products at office.com/setup.

Best 3 Ways to Upgrade to Windows 10 for Free

The Microsoft’s free offer for upgrading to the Windows 10 for free is officially ended. Interestingly, it is not entirely true at all. There are still not only one but several ways to upgrade to Windows 10 for free. Alternatively, you can do a clean reinstallation of Windows 10 on your computer and use it free.

Windows 10

Method 1: Using Windows 7, 8.1 or 8 key

Now you can’t use the Get Windows 10 application to upgrade to Windows 10 on your Windows 7 or 8 PC. Still, you can use the Windows 10 installation media tool to install it from scratch and when you asked to enter the activation key just put in your Windows 7, 8 or 8.1 key to continue the installation and activate the product.  

When you enter the old version key, it will communicate with Microsoft activation server and then authenticate your installation and activation. By installing this way, your operating system will remain licensed and completely activated.

Once the installation is done, you can easily check whether it is activated or not by navigating to Settings > Update & security > Activation.

Method 2: Upgrading to Windows 10 while Ignoring the Activation Alerts

In fact, you don’t have to enter a product key in order to install the Windows 10 on your PC while upgrading from previous Windows versions. Follow the below-mentioned steps to upgrade to Windows 10 without a product key:

1.      Download Windows 10 Installation Media tool.

2.      Install Windows 10 using it. 

3.      When asked to put in the activation key, just skip that and continue the installation.  

4.      Now you can freely use the Windows 10 even without the key.  

However, you will every time see a warning that you are using inactivated Windows 10.In case you don’t want to see the constant warning from Microsoft, then you can buy a product key right there, and your Windows 10 will be activated. Keep in mind that there are no issues in using the Windows 10 without activation, not even a single one problem is there.  

But if you want to put your own background in an inactivated Windows, then you will see the black screen again on next startup. Users also get 30 days free trial and afterwards you will begin seeing the activation warning.

Method 3: Re-installing Windows 10 If You has it Already

In case you already installed the Windows 10 for free during the free upgrade offer by Microsoft, even then you can re-install the Windows 10 if you want. There can be some reasons for re-installing the Windows 10 on your computer even though you have it on your device.

Keep in mind that you can freely install it again on your device without worrying about anything at all. Your Windows 10 license will not void no matter how many time you re-install Windows 10 on your device as you possess the license. But you might lose your Windows 10 license, in case you don’t have a Microsoft account linked to your device.

Make sure that you have signed in to Windows 10 with a Microsoft account, and that account should be set as an administrator account.  

To make sure that you don’t lose your Windows 10 activation during the installation, follow this guide:

1.      On your Windows 10 PC in which you want to re-install Windows 10, go to Settings.

2.      Then head to Accounts.

3.      Make sure you have signed in with your Microsoft Account, and the account is set as administrator.

4.      Then head to the Sync your Settings tab from the left menu.

5.      Make sure it is enabled.

6.      After that, you can use any method to re-install your Windows 10.

7.      Once the installation finishes, sign in with the same Microsoft account in your computer and sync the settings.

8.      Your Windows 10 will be activated.

Jaxson Harry is an avid technical blogger, a magazine contributor, a publisher of guides at mcafee.com/activate, and a professional cyber security analyst. Through her writing, she aims to educate people about the dangers and threats lurking in the digital world.

Source url: https://installermcafee.com/best-3-ways-to-upgrade-to-windows-10-for-free/

How to Fix Sysprep’s Fatal Error?

Windows is packed with countless underlying tools to enhance its functionality, and one such tool is the System Preparation Tool. However, there are times when you can face an issue like “a fatal error occurred while trying to Sysprep the machine” might appear on your screen. If you are facing it as well, then the blog can help you out. So, here are the steps to fix the error.

Edit SkipRearm Key

In case you intend to edit the SkipRearm key, then you can opt to follow the below-mentioned guidelines.

• Hold the Win + R keys at the same time on your system to launch the Run section.
• After that, input ‘regedit’ into it and select the OK button to launch the Registry Editor.
• Reach the Windows Registry Editor and go to the pursuing location: HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionSoftwareProtectionPlatform.
• Go to the right-hand side panel and find the SkipRearm button.
• You should twice click on the SkipRearm button to launch the Properties.
• Navigate to the Value data section and input 1 then select the OK button.
• Now, shut the Registry Editor and check whether the error is solved.

Edit CleanupState and GeneralizationState Keys

If the users are trying to edit GeneralizationState and CleanupState keys, then they should carefully apply the given steps.

• Hold the Win + R keys at the same time on your system to launch the Run section.
• Thereafter, input ‘regedit’ into it and select the OK button to launch the Registry Editor.
• In the Windows Registry Editor and go to the pursuing location: HKEY_LOCAL_MACHINESYSTEMSetupStatusSysprepStatus.
• Go to the right-hand side panel and find then twice click on the ‘GeneraliazationState’ button.
• Reach the Value data section and input 7, then select the Ok button.
• In case you cannot locate the ‘CleanupState’ button, skip the directions.
• Now, launch the ‘System Preparation Tool’ and look for any enhancements.

Fix Windows 10 Image

In case you intend to fix Windows 10 image, then you can opt to follow the below-mentioned guidelines.

• Hold the Win button to show the search bar.
• Thereafter, input ‘cmd’ into it and select the OK button.
• Select the Command Prompt, and right-click on it, then choose Run as Administrator.
• Go to the command prompt, type the pursuing command, and press the Enter key: DISM /Online /Cleanup-Image /CheckHealth.
• The over mentioned will execute an instant health check and identify it. There is any data corruption that requires repairing.
• In case any problems are identified, you should rebuild the Windows image through the pursuing command: ‘DISM /Online /Cleanup-Image /RestoreHealth.’
• The procedure may take some time to finish.
• Upon finishing point, it will show a success notification.
• Now, shut the command prompt and begin the System Preparation Tool.

Uninstalling MSDTC 

If the users are trying to uninstall MSDTC, then they should carefully apply the given steps.

• You should click on the Start logo on your system.
• After that, input ‘cmd’ onto it.
• Then reach the Command Prompt, and right-click on it, then choose the Run as Administrator.
• Go to the Command Prompt and input the pursuing command and press the Enter key: msdtc -uninstall.
• The over command will uninstall the server.
• If you would like to reinstall the service, input the pursuing command, and press the Enter key: msdtc -install.
• Now, launch the ‘System Preparation Tool.’

Deam Jones is a self-professed security expert; he has been making the people aware of the security threats. His passion is to write about Cyber security, cryptography, malware, social engineering, internet and new media. He writes for Norton security products at norton.com/setup.

How to Fix the 80072EE2 Error Code on Windows 10?

Despite being an efficient OS, numerous errors can occur on the Windows system. The OS is especially prone to more errors during the system update. At that time, it can encounter error codes like 0x80072EE2. There are several ways to fix it, and we will show to the easiest ones. So, here are the steps to fix the issue.

Disable Firewall

In case you intend to disable the firewall, then you can opt to follow the below-mentioned guidelines.

• Go to the Start button and click on the Control Panel on your system.
• After that, input ‘Firewall’ into the Control Panel’s search section.
• You should select the Windows Firewall option.
• Navigate to the ‘Turn Windows Firewall On or off’ option and click on it.
• Then input the administrator account password in the shown pop-up on your screen.
• Go to the ‘Public network settings’ and tick the ‘Turn off Windows Firewall (not recommended)’ entry.
• Now, click on the OK button to apply the changes.

Launch Windows Update Troubleshooter

If the users are trying to launch the Windows Update Troubleshooter on Windows 10, then they should carefully apply the given steps.

• Navigate to the Settings and launch it on your system.
• After that, go to the Update and Security option.
• You should click on the Troubleshooter option in the left-hand side panel.
• Go to the Windows Update and select Run the troubleshooter option.

Whitelist Windows Update Servers

In case you intend to whitelist Windows update servers, then you can opt to follow the below-mentioned guidelines.

• Go to the Start and launch it and input ‘internet options’ into the search section.
• You should click on the ‘Internet Options’ and go to the Security section.
• After that, select the ‘Trusted Sites’ option.
• Then click on the Sites option.
• Navigate to the shown Trusted sites section, untick the box of ‘Require server verification (https:) for all sites in this zone’ at the bottom of the screen option.
• Reach the ‘Add this website to the zone’ section and input ‘http://update.microsoft.com’ and ‘http://windowsupdate.microsoft.com’ addresses.
• You should click on the Add option once you enter each one of them.
• Now, select the OK button to apply the changes.

Reset Windows 10 Update Components

If the users are trying to reset Windows 10 update components, then they should carefully apply the given steps.

• Go to the Start option and input ‘cmd’ into the search section on your system.
• Reach the Command Prompt and right-click on it then select the ‘Run as administrator’ option.
• Navigate to the Command Prompt and input this software then select the Enter button after each one of them:
• net stop wuauserv
• net stop cryptSvc
• net stop bits
• net stop msiserver
• After executing these commands, input the pursuing ones to change the name of the folder ‘SoftwareDistribution.’
• You should click on the Enter button after each one of them:
• ren C:\\Windows\\SoftwareDistribution SoftwareDistribution.old
• ren C:\\Windows\\System32\\catroot2 Catroot2.old
• Input the pursuing commands to reboot the ‘Update Components’ that you turned off in the second instruction.
• Make sure to press the Enter button once input each one of them:
• net start wuauserv
• net start cryptSvc
• net start bits
• net start msiserver
• Later, shut the Command Prompt.
• Now, reboot the system.

Launch System File Checker

In case you intend to launch a system file checker, then you can opt to follow the below-mentioned guidelines.

• Navigate to the Start and input ‘cmd’ into the search section.
• You should reach the Command Prompt, and right-click on it then select the Run as administrator.
• Then input ‘sfc /scannow’ and hit the Enter key.
• Now, you have to wait till Windows finishes the scan process and reboot the system.

Jaxson Harry is a self-professed security expert; she has been making the people aware of the security threats. Her passion is to write about Cyber security, cryptography, malware, social engineering, internet and new media. She writes for Microsoft products at office.com/setup.