Some Icon Set Images in Excel Won’t Print

August 1, 2014 Leave a comment

The original file that prompted this post had many more elements in it than the example I will use. I’ve cut out a lot of the hours (and I mean hours) of random troubleshooting tangents I went on and tried to simplify it to get to the core of the issue. This one is going to be a screenshot happy post.

A user reported an issue she was having with an Excel file where some images were not printing. The spreadsheet has grouped rows with summary rows for each. There is a Conditional Formatting rule that displays the green, yellow, and red icon sets based on percentages. The print area has been set to include only the cells with data.


Groups collapsed

1 Collapsed

Groups expanded

2 Expanded


Conditional formatting rule

3 CF Rule


When printing some of the icons in the print preview (and the print job) were missing.

4 Print Preview

If I remove the print area and expand the groups they all show up in the pint preview.

5 Print Preview

So what’s causing this??? Merged cells and page breaks. More specifically, when merged cells are outside of the print area but are adjacent to cells that contain an icon from a conditional formatting rule, the icon will not print. In the screenshot below I have filled in the merged cells in blue.

6 Merged Cells

In the current scenario B3, B8, and B13 would be an issue but they are not currently on a page break. B18 and F7 on the other hand are a problem because they are outside the print area but right next to a cell that contains an icon. When a group is collapsed it is technically no longer considered to be in the print area.

The fix is simple, unmerge the cells. Now the print preview shows the icons!

7 Print Preview


This is definitely a bug.

Here’s a link to my sample file if you are interested. Sample.xlsx

Quick Post: PSEXEC & WOL

Ever need to wake up a computer on a subnet that the “magic” packet can’t reach? Use PSEXEC to remote to a powered on computer on that subnet then run WOL.

psexec \\computername -c wol.exe mac_address


PSTools –


Categories: Computers Tags: , ,

Can’t Delete Folder


When trying to delete a folder you get an error that says, “An unexpected error is keeping you from deleting the folder. If you continue to receive this error, you can use the error code to search for help with this problem. Error 0x80070091: The directory is not empty.”

delete error

Problem is the directory is empty. After a reboot you still get the error.



  • Right click the drive that the folder is on & click Properties.
  • Select the Tools tab.
  • In the Error checking frame click Check.
  • When prompted click Scan and repair drive. (Damn forgot to take a screenshot)
  • On the Your drive was successfully repaired screen click Close.
Categories: Computers Tags: ,

Reset Password on Canon iR3230

  • Press Additional Functions.
  • Press 2 & 8 at the same time.
  • Press Additional Functions.
  • Press Copier.
  • Press Function.
  • Press Clear.
  • Press PWD-CLR.
  • Press OK.
Categories: Computers Tags: , , ,

Hyper-V Host Can’t Get to the Internet

The Configuration

Windows 8.1 Pro with the Hyper-V Role installed. One physical NIC with a static IP address.

1 static ip

Configure an External Virtual Switch bound to the physical adapter.

2 virtual switch

The Problem

Virtual machines can get to the Internet just fine but the Hyper-V server cannot.

3 no internet

Hyper-V server can’t even ping Bing.

4 no bing ping

Hmmmm…can’t even resolve Looking at the IPv4 properties of the vEthernet (External) NIC there is no DNS configured.

5 no dns

The Solution

Add the IP of the router (or whatever DNS server you use) back in for the DNS server(s). Now the Hyper-V server can access the Internet.

The Cause

When creating the External Virtual Switch a dialog box popped up that said, “Pending changes may disrupt network connectivity. This computer may loose blah, blah, blah”. But then it says, “These changes also may overwrite some static changes. If that happens, you must reapply the static changes to restore network connectivity.”

6 apply network changes

So there you go. When configuring Hyper-V to use a NIC that has a static IP configured you may loose some or all of it when it moves those settings to the vEthernet NIC.

DBAN Error

When booting a Dell OptiPlex 760 to Darik’s Boot and Nuke (DBAN) you receive a few messages/errors that say:

  • BIOS EDD facility v0.16 2004-June-25, 0 devices found
  • EDD information not available.
  • Warning: unable to open an initial console.


Solution – Upgrade the BIOS to A15 then try again.


Categories: Computers Tags: , , ,

Zero objects in vCenter

After rebooting the vCenter server & logging into the vSphere Web Client I noticed that all objects in the Inventory List had a quantity of 0.

1 Zero

A quick glance at the services showed that the VMware VirtualCenter Server, VMware VirtualCenter Management Webservices, & a few others were stopped. When starting the VMware VirtualCenter Server service I received an error that said, “Windows could not start the VMward VirtualCenter Server on ServerName.”

2 Error

In the Application log there is an Event ID 1000 that says, “The description for Event ID 1000 from source VMware VirtualCenter Server cannot be found. Either the component that raises this event is not on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: Failed to initialize VMware Virtual Center. Shutting down… the message resource is present but the message is not found in the string message table.”

3 Error

There is also a corresponding Event ID 7024 in the System log that says, “The VMware Virtual Server service terminated with service-specific error The system cannot find the file specified.”

4 Error

Browse to %ALLUSERSPROFILE%\VMware\VMware VirtualCenter\Logs & open the newest vpxd-XX.txt file. Near the end of the file you find some entries similar to:


2014-03-07T19:23:54.477-06:00 [01784 warning 'Default'] Closing Response processing in unexpected state: 3

2014-03-07T19:23:54.478-06:00 [01784 error ‘[SSO][SsoFactory_CreateFacade]‘] Unable to create SSO facade: Invalid response code: 404 Not Found.

2014-03-07T19:23:54.478-06:00 [01784 error 'vpxdvpxdMain'] [Vpxd::ServerApp::Init] Init failed: Vpx::Common::Sso::SsoFactory_CreateFacade(sslContext, ssoFacadeConstPtr)


Restart the VMware Identity Management Service. Then start the VMware vSphere Profile-Driven Storage Service, VMware VirtualCenter Server, & VMware VirtualCenter Management Webservices services.


Categories: Computers Tags: , ,

vCenter General Settings Page Stuck on “Loading”

In the vSphere Web Client when navigating to Manage>Settings>General on the vCenter server the page says “Loading” but never loads.


To resolve the issue restart the VMware vSphere Web Client service.

Error Starting Virtual Machine

When starting a VM you receive an error that says, “The application encountered an error while attempting to change the state of ‘COMPUTER1′. ‘COMPUTER1′ failed to start. Microsoft Virtual BIOS: Failed to resume with error ‘The specified network resource or device is no longer available.’ ‘COMPUTER1′ failed to start. (Virtual machine A36421CC-9462-4B43-82E6-DE14B5579EE1). ‘COMPUTER1′ Microsoft Virtual BIOS: Failed to resume with error ‘The specified network resource or device is no longer available.’ (0x80070037). (Virtual machine A36421DC-9462-5B43-82E6-DE14B5579FE1)”


The VM is then stuck in the Starting state.


If you try to connect to the console of a VM you receive an error that says, “An error occurred trying to find the virtual machine ‘COMPUTER1′ on the server ‘HYPERV’. The computer ‘localhost’ failed to perform the requested operation.”


If you refresh Hyper-V Manager the VM is gone from the list.

The fix in my case was to add an exception in the AV software on the server to exclude the folder where the VHD files are from the real time scan.

Ref –;EN-US;961804

Categories: Computers Tags: ,

Remove an OEM Recovery/Boot Partition

Warning: This post deals with editing the boot configuration of your computer. If you don’t know what that is stop right here & ask someone else to help you. Editing the boot configuration incorrectly can cause serious problems that may require you to reinstall Windows. Use the steps below at your own risk.

I recently had a situation where Windows Server 2008 R2 was installed on a Dell OptiPlex 7010 that came with an OEM installation of Windows 7. During the  Windows Server 2008 R2 installation process all partitions were not properly deleted. The result was that the 10GB OEM recovery partition was left intact which also meant that it remained the boot partition. Fast forward a few months & I needed to P2V the computer. Now I’ve got a VM with 10GB of wasted space & a boot configuration which is a mess.


Now the following steps may vary depending on your situation. As always there are several ways to get the same result. In my case here’s what I did. Note that all commands should be run from an elevated command prompt.

First set the C drive as the active partition. Open Disk Management right click the C drive & select Mark Partition as Active. Now it should look a little more like this.


The issue now is that the actual boot files are on the Recovery drive & boot manager will still look to the recovery partition for the boot files.



Copy the boot file to the C drive by running bcdboot c:\windows /s c:


Just in case make a backup of the boot configuration by running bcdedit /export c:\temp\bcs\backup

Note that the C:\Temp folder needs to exist or you will get an error.

Now set the C drive as the boot partition by running bcdedit /set {bootmgr} device partition=C:

Verify the change by running bcdedit as well as looking at Disk Management.



Unfortunately with the recovery partition being at the beginning of the disk there is not a built-in way (that I’m aware of) to just delete the partition & reclaim the space without the use of 3rd party utilities. In my case the easiest option was to do a V2V migration (virtual to virtual) of the VM. During the process I did not migrate that partition since it is no longer a system partition. Once that is done I booted up the VM. Now no more OEM partition.



Get every new post delivered to your Inbox.

Join 139 other followers

%d bloggers like this: