Thursday, August 27, 2015

finding and breaking external excel links

Apart from the great tips all over the internet such as this one

http://tjshome.com/blog/249/guide/excel/accounting

I find very common when using conditional formatting and copy/pasting from one sheet to another that this link gets created with a reference to the original file. Break links doesn't really break them. Find them by clicking on

Home ribbon, Conditional Formatting, Manage Rules

change the "Show formatting rules for:" drop down to "This worksheet" and look for anything referencing a file instead of a rule, like in this case:



Change the formatting and you are set.

Thursday, August 13, 2015

Adding Dell's and HP's download source URLs to VUM to get updates automatically

This is a short and sweet one. By default VMware adds some URLs to VUM: 




Here is the URL to add Dell (very useful if you install the OMSA vib, for example):

http://vmwaredepot.dell.com/index.xml



Don't forget to click on Apply and Download Now if you are in a hurry :)

Check the patch repository, sort by vendor and you will see new vib packages. I do believe it only shows packages applicable to your hardware




HP's is http://vibsdepot.hp.com/index.xml