Contact Info

Atlanta

Category Archives

How To : Remove passwords / editing restrictions on MS Word and Excel Files

Have you ever come across a word or excel document that was ‘password protected’ – where certain parts of the document you were unable to edit?

Frequently these are used in business settings, and with good reason – to protect formulas, proprietary information, sections of contracts, et cetera.

But, sometimes you need to edit a restricted document, and your colleague is not at their computer or out to lunch, on vacation, or otherwise missing in action. Not to worry, we’ll show you how to remove the password from a restricted Word or Excel document. All you’ll need is MS Office 2007/2010/2013, the free software 7-Zip (which we recommend everyone use for archive management!), and a bit of technical support know-how from your local IT pro.

tech-tip-remove-word-password-protection-1
1. Ensure your file is in the latest .docX or .xlsX format. If your file is in an earlier office format, do a ‘Save As’, select ‘docx’ as the format type, and make sure you leave the ‘maintain compatibilty’ box empty. We want the latest file format.

tech-tip-remove-word-password-protection-2

2. Open windows explorer and find your file. Make a copy of the file, and change the file extension from .docx to .zip.

tech-tip-remove-word-password-protection-3

3. Right click the .zip file, and using the 7zip context menu, ‘Open Archive’ using the 7zip archive manager. This will allow you to edit the .docx archive without extracting the XML files inside.

tech-tip-remove-word-password-protection-4
4. Navigate to /word, and find the settings.xml file. Right click the file, and select ‘edit’. – This is important, do not choose ‘open’ or any other option – only ‘edit’ will work.

atlanta-it-support-remove-word-password-protection-5
5. Find the XML element beginning with w:documentprotection, highlighted in the screenshot above. Remove the entire element, including < and > brackets.

6. Save, close, and update the archive when prompted.

7. Rename your file, changing the .zip extension back to .docx

8. Enjoy!

Hopefully this has assisted someone out there in Atlanta, and let us know if this solved your IT support needs in the comments!

Thanks to this post on Spiceworks, and this helpful blog : http://itintheory.blogspot.com/2012/06/remove-editing-restrictions-in-word.html for the inspiration.

 


Using Euclid Network’s Logmein PRO Remote Access Portal

For current partners on IT support plans, we offer a complimentary remote access portal, utilizing a full featured license to LogMeIn PRO. This license is valid for all the machines you currently have on a plan with us, and the remote access portable is configurable in a variety of ways.

VIDEO INSTRUCTIONS HERE : http://youtu.be/XYgXLRi5Ts8

To gain access to your personalized portal, please contact us directly. Once you have received your credentials, please log in and use the portal using the following procedure :

1. Visit the portal at https://user.itsupport247.net/

Euclid-IT-Support-Logmein-Remote-Access-Atlanta-1

2. Enter your portal username and password, as provided by our staff. Select the check box ‘Remote in to Favorite Desktop’ for faster access in the future. You will then be prompted to set up Two-Factor Authentication for your account, along with link and guidelines on doing this using a Google, Microsoft, or Authy smartphone app. If you are in a hurry, you currently may select ‘skip’ to bypass this step temporarily.

3. Once 2FA is set up, on the portal homescreen, you will see a list of computers you have access to. To the left of the computer name, there are three icons highlighted in the screenshot below. In order, they are : “Remote Control”, “System Info”, and “Favorite”

4. Click the star to favorite your most used computer. Then, click the left icon to establish a Remote Control session. The next screen should appear, asking you to install the remote access software. This is a one-time installation, and will not need to be done every time you connect.

Euclid IT Support Logmein Remote Access Atlanta 3

5. This screen may appear differently depending on which web browser you use. Follow the prompts to install the LogMeIn plugin. Once installed, you should connect to the computer.

6. Once connected, you will be prompted to enter the login information for your computer. This is the username and password you normally use while physically at the computer, not the remote access website password you entered earlier.

7. Success! You are now connected to your system. Select ‘Remote Access’ from the menu.

8. You may be prompted to update your windows firewall settings the first time you connect. This is a one time adjustment. Select all the checkboxes highlighted above, and “Allow Access”

9. You can now control your system remotely as if you were sitting in front of it. There are a few notable icons on the top bar, as highlighted in the screenshot above:

  • On the left side, the icon with two overlapping rectangles lets you switch screens on your remote computer, if your office computer has a multi-monitor setup.
  • The middle icon we’ve highlighted looks like a pyramid. This button will send CTL-ALT-DEL to the remote computer.
  • On the right, we’ve highlighted the ‘fullscreen’ and ‘x’ buttons. This will make the remote control session go fullscreen, allowing you to be more productive.

That’s it! If you have questions or need IT assistance with your computer’s remote access software in Atlanta, please contact us directly at 404-593-0083404-593-0083+14045930083+14045930083” data-isfreecall=”false” data-isrtl=”false” data-ismobile=”false”>404-593-0083404-593-0083, or by e-mail at info@euclidnet.com.


Windows Update / Windows Defender gives error 0x8024401C

We see this error typically when there is a network connectivity problem between Windows Update or Windows Defender, and Microsoft’s servers. This problem can occur even when the machine in question has access to the internet, if there is a problem with the windows firewall, erroneous proxy settings, or a corrupted Windows Update database.

For Windows 8, or 8.1, Microsoft has an automated tool that can help check on the status of the database, and in some cases resolve the issue outright. This tool can be found at : Microsoft Source : http://windows.microsoft.com/en-us/windows-8/windows-update-error-0x8024401c

If this automatic tool fails to resolve the problem, attempt the following :

WindowsUpdateFailed-Troubleshooting-Steps

 

 

 

 

 

 

 

 

 

  1. Open an Elevated Command Prompt
  2. Type “SFC /scannow” – this will check your windows system files for corruption and repair if possible. If corruption is found, troubleshoot further into hardware failure issues.
  3. Bring up a control panel, and select internet options
  4. In internet options, select “connections”. On the connections screen select “LAN Settings”
  5. Ensure under LAN Settings, the ‘Automatically Detect Settings’ box is checked.
  6. Hit OK, exit out. Reboot if needed, and attempt to update windows again. Problem should be resolved.

Windows won’t start after Microsoft Update installation

Windows won’t start after update installation

This is a common problem we run in to while providing IT support with older computers. After applying a Microsoft Update patch, windows will partially boot, or not boot at all. Most of the times, windows will boot to its start screen, with a message similar to the below :

“Configuring Windows updates… 90% complete… Do not turn off your computer.”


USB Displayport Adapter causing BSOD with Intel HD4000 Graphics

This computer problem was a bit tough for us to figure out originally. We had a local IT partner who was getting the blue screen of death when their USB to VGA displayport adapter was plugged in to their Asus Vivobook S400CA laptop computer running windows 8. If we unplugged the USB displayport adapter, no bluescreens.


How to : Move Mozilla Thunderbird Profiles to a new (or different) computer in Windows 7

Moving profiles for the Thunderbird e-mail client is a pretty common task we have to do for support partners who get a new office computer, and use Thunderbird. Thankfully, unlike Microsoft Outlook, Thunderbird profiles are relatively easy to copy over between computers – thanks Mozilla!

Step 1 : Copying over your existing Thunderbird profile.

Thunderbird profiles are stored at : %APPDATA% \Thunderbird\Profiles\<Profile name>\


Unable to join Windows 7 Workstation to SBS 2008 Domain

“Your computer could not be joined to the domain because : An attempt to resolve the DNS name of a domain controller in the domain being joined has failed.”

We run into this error a lot on improperly configured SBS 2008 domain servers. The issue usually has to do with improper DHCP settings on the domain controller – where an external DNS is listed before the domain controller’s IP address in your IPv4 settings. Check that your domain controller is listed as your primary DNS server – for instance DNS settings should look like this on your client computer :


Page 2 of 212