Home Blog

Firefox doesn’t have HP Client Security Manager plugin Windows 7

0

In Windows 7 with HP Client Security program installed you will get a popup from the system tray from time to time advising you that Firefox needs a plugin enabled so as to integrate your password management with windows.

Clicking the popup brings up the HP Client Security program options under HOME > Password Manager > Browser Integration

Their instructions for Firefox indicate that you can simply open the FF addon page and enable the HP Client Security plugin. But….that plugin was nowhere to be found on my system nor in the FF addon library.

You might be able to find the plugin somewhere if you look hard enough (I did a quick search and the initial results were less than helpful).

That being said, if you don’t care about integration and simply want to turn off the notifications, then uncheck the blue checkbox under the Firefox section of this page.

NOTE: If you have Windows 10 then your options are different. Some people have had luck following instructions located here: https://h30434.www3.hp.com/t5/Commercial-PC-Software/HP-Client-Security-keeps-nagging-me-to-install-a-Firefox/td-p/5945235

Use at your own risk.

How to find zombie orphan broken links in an Excel document

0

Had a bear of a time finding a bad link to an external file inside an Excel document. As is usually the case, this was a spreadsheet of many tabs, some of which were hidden. There were formulas, Data validation and conditional formatting galore! The perfect place for a broken reference to hide.

So what can you do when you’re being tormented by the broken links notification at startup? Assuming you’re like me and cannot ignore the problem, you immediately set to work figuring out where the bad reference is by looking at some likely cells. Maybe you perform a FIND operation using the name of the missing file. And when you fail at those tasks, you then attempt to remove the reference and simply deal with whatever fallout occurs. Excel is nice enough to offer a way to do this in the form of a ‘break link’ button which usually operates as it’s name would imply. But what do you do when even that button doesn’t work?

You can try using the ideas offered by Microsoft here, but if you want to zero in on the problem a bit quicker, first you need to:

Find the offending Tab

  • Assuming an XLSX file, Save a copy of your spreadsheet as a .zip and UnZip it to a folder.
  • Search that folder for the name of the broken external link. You will get back sheetN.xml as one of the results. N is the number of the Tab which has the bad reference somewhere on it. (Count over from the leftmost tab in your workbook tab by tab to find that sheet(tab) number. Hidden tabs can count as well, if they fall between the first tab(sheet) and the offending sheet. So you may want to Unhide them temporarily. Alternatively, you can look at the code inside sheetN.xml (from the batch of files you unzipped) using a text editor like Notepad to see if you recognize which Tab in your original workbook it comes from. That worked for me.
  • If you look more at the code surrounding the offending external reference, you may be able to determine where on the sheet the issue is and whether it’s a formula, conditional formatting or data validation reference which is messed up. If you cannot figure it out, you may need to rebuild that Tab as a new tab. That worked for me.

This tip was brought to you by the amazing community over at SuperUser. Here is a back link to the post I used to help solve my issue:

https://superuser.com/questions/719931/how-to-find-broken-links-in-excel-that-cant-be-broken-with-break-links

Axcient Backup failed on Domain Controller SQLVDI error

0

If your Domain Controller is using Azure AD Connect, it may have recently updated itself and caused the SQL VSS Writer to start failing when your backups try to kick off a snapshot.

In the Application Log you may see something like this:

SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=1924. Thread=2788. Client. Instance=LOCALDB#DatabaseName. VD=Global\{RegistryID}1_SQLVDIMemoryName_0.

The fix:
Open up Programs and Features and ‘Repair’ the installation of Microsoft SQL Server 2012 Express LocalDB. Reboot and re-run your backup.

*This also appears to be responsible for recent failures to backups done using VEEAM as well. Same fix.*

For this fix I used a blog post here: http://www.tecfused.com/2016/09/veeam-backup-fails-vss-writer-errror-0x800423f4-azure-ad-connect/
They also have a script posted in the comments which might come in handy if your client has multiple servers to update or if you find the backups failing often and want a more long-term (though not permanent) solution.

Word opening Compatibility Mode for all documents even NEW

0

Try this first:

Convert your “Normal” template to the current office version

The Normal.dotm template is stored in a hidden folder. The simplest way to open it is this way:

  • Open a blank document and Press Alt+F11 (opens the macro editor)
  • Press Ctrl+G to open the Immediate window at the bottom of the editor
  • Type this into the Immediate window and press Enter:

NormalTemplate.OpenAsDocument

  • You should see the normal.dotm file open up in its own window. Go ahead and close the macro editor window and switch to the normal.dotm window. Check the Title Bar. If it says [Compatibility Mode], go to File > Info and click the Convert button. Then save and close the template. This fixes Compatibility Mode issues with new documents.

    If older documents still show [Compatibility Mode] and you are planning to use new features in those files then you can use File>Info and Convert those as well. In most cases you will not need to Convert them.

Excel crashing with video driver error Intel Graphics HD 530

0

This note is regarding crashes of Excel on Windows 7 when searching rows and columns. Excel will crash with a video driver error (also Skype crashes).

The fix appears to be newer drivers for the Intel chip (when installing, some people recommend to untick the box to enable Aero), but if you still have issues as some people do, you can hack the registry to increase the timeout of the video driver.

From Microsoft’s site here:

To Change the Graphic device timeout, use the following steps.

  1. Exit all Apps and Programs.
  2. Press the WinKey+R keys to display the Run dialog.
  3. Type  regedit.exe  and click OK to open the registry editor.
  4. Navigate to the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\GraphicsDrivers

 

  1. With the GraphicsDrivers key selected, on the Edit menu, click New, and then select the following registry value from the drop-down menu specific to your version of Windows (32 bit, or 64 bit):

(NOTE: The TdrDelay name is Case Sensitive)

For 32 bit Windows

a. Select DWORD (32-bit) value.

b. Type TdrDelay as the Name and click Enter.

c. Double-click TdrDelay and add 8 for the Value data and click OK.

 

For 64 bit Windows

     a. Select QWORD (64-bit) value.

b. Type TdrDelay as the Name and click Enter.

 c. Double-click TdrDelay and add 8 for the Value data and clickOK.

 

Close the registry editor and then restart your computer for the changes to take effect.

View Shared Outlook calendars on iPhone iOS

0

The setup:
Exchange Online user. Has a secondary shared calendar in their account which is shared with other team members with access to put items on it.

The need:
Team members would like to use the calendar from their mobile devices, but it doesn’t show on theirs, only shows on the owner’s mobile.

The fix:
Have the owner un-share it, then Send a sharing invitation in email to re-share it with each team member from the Office Online Calendar interface. Make sure you select the proper permissions for that user.

On your mobile, use the Outlook App(iOS and Android) and open the “I’d like to share my calendar with you” email and then add the shared calendar to your account.

Reference: https://support.office.com/en-us/article/Share-your-calendar-in-Outlook-on-the-web-for-business-7ecef8ae-139c-40d9-bae2-a23977ee58d5?ui=en-US&rs=en-US&ad=US#__toc375064923

PS. Beware of advice to publish your calendar to the web and use the link…I haven’t studied all the ramifications of doing this, and naturally it depends how sensitive your calendar info is, but in general I’d advise against this unless you are sure it’s what you want.

————

If you’re looking for some general guidelines on how to add a calendar from a Shared Mailbox to iOS then refer to this link here: http://help.unc.edu/help/accessing-a-shared-calendar-on-ios/
Note: the steps in the link above will publish your calendar to a direct link which is considered insecure because it can potentially be shared with others outside your organization.

Microsoft Outlook 2016 Office 365 hang on processing

0

Over 400 people found this tip helpful…

  • Close Outlook, Right-Click on Outlook icon. Select “New Email Message”.
  • Keep it open. Right-Click on Outlook icon. Select “Outlook 2016”, should open fine.
  • Close the email message window and Outlook and test after that..should be OK.

If this doesn’t work…google some more!

*Special thanks to Eric Saenz via answers.microsoft.com

Office 365 Remove a search for in-place eDiscovery and hold after mailbox deleted

0

You place the mailbox on hold, but delete the mailbox. The search cannot be removed while there is a hold. So..you need to remove the hold. You can do this with a remote powershell session and this command:

Set-MailboxSearch -Name Searchname -InPlaceHoldEnabled: 0

Wait a minute, refresh the compliance page and the in-place hold should be = NO
Then you may delete the hold.

*Remote Powershell*
Open PS in administrative context
Run: Set-ExecutionPolicy RemoteSigned
Then Run:
$LiveCred = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange-ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection
Import-PSSession $Session

NOTE: When prompted for credentials, enter your Office 365 admin username/password or one that has admin rights for the tenant.

Store iPhone backups in the cloud or in DropBox (PC)

0

A client approached me to inquire about using cloud storage for, well, everything. They wanted their laptop to dock with a USB hard drive that was synced with DropBox (cloud storage). Since they have an iPhone, naturally they wanted to see about storing iPhone backups in the cloud.

My first thought was, your backups need to be Encrypted. After that, store them wherever you’d like! Of course, if you don’t wish to store them locally (Apple default save directory), then you can make one simple change to your system which will redirect where iTunes stores those backups. To make this happen, we use a Symbolic link – which is a type of Shortcut that tells the File System to look in another place for the folder iTunes is expecting to save your backup in. It’s completely transparent to iTunes.

For PC

iTunes backups are stored in “C:\Users\*USERNAME*\AppData\Roaming\Apple Computer\MobileSync\Backup”

To move this folder’s location:

  • Copy the folder to the new location (for example: the DropBox folder on your USB drive)
  • Either keep the original folder name of Backup or rename to something more descriptive. I like “iPhone Backups”
  • Go to the original folder location “C:\Users\*USERNAME*\AppData\Roaming\Apple Computer\MobileSync\”
  • Either delete the folder “Backup” or rename it “BackupOld” to keep it
  • Press Shift+Right Click and select the option to open a Command window here
  • Type the following command:

mklink /J "%APPDATA%\Apple Computer\MobileSync\Backup" and "<DropBox path>:\iPhone Backups"

  • Close Command prompt
  • Launch iTunes and see if it locates the backup

Note: Make sure you check your cloud storage for the backup as well. It may take a while to upload.

 

For Mac instructions, please use this excellent resource: https://support.imazing.com/hc/en-us/articles/203504123-Storing-your-iPhone-Backups-on-an-Alternate-Location

FileZilla cannot View Edit Excel documents remote document

0

This issue arises with FileZilla possibly due to lack of native support for the XLSX file extension. The fix is to manually map the associations for Excel in FileZilla (you may not need both, but I included xls for good measure):

 

  • In FileZilla goto Settings, then File Editing / File Type Associations
  • In the Custom filetype associations pane, enter in the following:
    • xls “C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE”
      xlsx “C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE”

Obviously you will need to use your own path for Office and the excel executable.

The same process would apply if you noticed trouble with the DOCX file extension or any other filetype you are trying to VIEW/EDIT from FileZilla.