25 Jul

Unlocking A Protected Excel File

We had a Excel file that we needed to copy some of the cells to recreate a new proposal. The Excel file was locked, so we could view it but couldn’t copy anything.

I found the following link that helped me unlock the document.

How to protect and unprotect Excel sheet with or without password

I had to use the script and the VBA code to get a temporary password. This temp password allowed me to edit the document and do a Save As.

Let us know if this helps you…

 

17 Jul

Gmail in Outlook – Can Log Into Gmail But Outlook Won’t Authenticate

Had a customer who needed to change their Gmail password. When they opened Outlook it asked for the  new password, so they entered it. Outlook keep prompting for the new password.

The customer could go to Gmail and log right in.

It turned out to be Google needs this account to be “Less secure apps” section of your Gmail account. It should be here https://myaccount.google.com/lesssecureapps. Turn on this feature.

Let us know if this solution helps you…

 

 

13 Jul

Using RegEx to Get IP in Google Analytics

For privacy reasons Google doesn’t just offer up the IP addresses of your traffic, but there are ways to get it. I have set up a filter in my Analytics account to accomplish this.

Here is an article that helped me figure this out.

Basic Google Analytics Filters for Every Site

Here is the page that helped me determine the regular expression needed to include the IP address information.

http://www.regular-expressions.info/ip.html

Let us know if this helps you….

 

10 Jul

Unable to search in Outlook – Search Results may be incomplete because items are still being indexed.

Had a customer with Outlook 2007 that started receiving this message after a recent Microsoft update.

I used the advice from this video to help solve the issue.

https://www.youtube.com/watch?v=uFnXPaMxyUo

Let us know if this helps you…

 

21 Jun

Sonicwall VPN Client connects just fine but can’t access intranet site – Windows 10

Scenario:

Downloaded Sonicwall Firewall (multiple versions 4.10.2.0428, 4.10.1.0317, 4.9.22.0822, 4.9.14.0427, 4.9.9.1016) and tried one at a time. The connection is solid. The client connects to the home office just fine, you CAN ping resources via IP, but you CAN’T browse to intranet site although you can ping it.

Trying to navigate to an intranet site using Chrome or Internet Explorer, you’d get the following error:

 

After spending countless hours troubleshooting in the wrong direction, the simple and only resolution was to enable Jumbo Frame for the NIC card in use. 

Here’s how…

  1. Open ‘Network and Sharing Center‘ – (you can type that in the start menu)
  2. Click ‘Change adapter settings’ from the left pane
  3. Right-click the NIC for which you want to enable jumbo frames and select ‘Properties‘.
  4. Click on ‘Configure‘ Under the Networking tab
  5. Click on the ‘Advanced‘ tab
  6. Select Jumbo Frame on the left and change the value from disabled to the desired value, I put mine at 9kB MTU
  7. Then click ‘OK

That’s all!

 

13 Jun

Submitting Suspicious Emails to Barracuda For Review

With the WannaCry threat going around we not taking any chances with suspicious emails getting through our Barracuda firewall. We are submitting any suspicious emails to Barracuda using the following web address.

http://barracudacentral.org/report

Let us know if this helps you….

 

12 Jun

Outlook 2013 – Metered Connection Warning.

Had this issue with a customer with Outlook in completely in Spanish.

 

In add/remove programs I removed the FR and ES versions of office.

Ran “change” and then “repair” on the existing EN Office installation.

Let us know if this helped you…

 

01 Jun

Domain Expiration SEO Registration Is Set To Expire – Scam

We have recently received a couple of emails asking us to re-register our SEO ( Search Engine Optimization ). There is a link to pay.

This is obviously a scam. The SEO are carefully crafted words in the webpage. You can pay someone to craft the SEO and put it in the page, but you don’t need to “register” anything.

The company is qualiSEO.org. They charge $75.00 per year with multi-year discounts.

Let us know if this helped you..

 

31 May

Is Google Ranking Websites With SSL higher?

We have been hearing about this since the beginning of the year, and yes we are hearing this from our hosting companies. We used Sucuri a number of times to have a some nasty website attacks cleaned up. They have also recently paired up with some hosting companies such as SiteGround because of the number of attacks across the web.

I watched a recent webinar from Sucuri and they are saying it is true that Google will make your site less important in their search results if you are not using an SSL. This is for straight HTML sites as well as an CMS ECommerce site.

The cost for an SSL is around $100 per year. Installing the SSL and configuring your website to work with the SSL takes a bit of work, but we are use to it. If you are interested in upgrading your site security and need some help feel free to contact us.

Let us know if this helped you…

 

19 May

Windows 2012 R2 Server – Critical Memory Error – An Error Was Detected During Memory Initialization

We used a remote support connection to fix a customer’s server. When we were finished patching the server it required a reboot. 30 minutes later the machine wasn’t back on-line we went on site. When the tech walked in he say the following error on the screen.

He discovered the cause was:

The event log within BIOS contains one or more events that should be diagnosed before continuing.

The fix was:
Check the event log in the BIOS, address the issues listed, clear the log and run the diagnostics again to confirm that no further issues are detected. ”

Let us know if this helped you…