Links to Entites in Excel Generated by Metadata Document Generator for Dynamics CRM 2011

Metadata Document Generator for Dynamics CRM 2011 is a nice tool  you can create documentation of your CRM entites with.

Created Excel document is even nicer if you add links to tabs, so finding a specific entity is faster. This is how I did that (in Excel 2010):

1. I added new column to the Entities list -tab next to the Entity.
2. I used formula =HYPERLINK(CONCATENATE("#'";LEFT(CONCATENATE(A7;" ("; E7; ")"); 31);"'!A7"); A7)
3. I hid the original Entity-column

This formula can of course be applied to any list in Excel that corresponds to tab names.