PowerPivot – Rename my Excel Table Names

When you are working with Excel Linked Tables as data sources for PowerPivot, you may notice that the name you labelled the table name (in Excel) has not imported into the PowerPivot data model as you expected.  Instead you might see the name “Tablexx” where xx is a number rather than the custom name you gave the table back in Excel.  Whilst you can rename the Table within the PowerPivot model, “Tablexx” still gets pumped back out when you browse the PowerPivot model in a Pivot Table or Chart.

As a workaround, delete the table from the PowerPivot model, then in Excel, go to Formulas, then Name Manager.

NameManager

Within Name Manager you can then Filter to Tables, remove any duplicate references, then rename the name “Tablexx” to a custom name.   Now when you add back into the PowerPivot data model this time, the custom name will come across and display correctly when you browse the model in a Pivot table or chart.

NameManagerFilterTables

 

If you want to read more about Table naming in Excel, there is a fabulous read here

http://searchengineland.com/a-marketers-guide-to-table-formatting-in-excel-124944.

Enjoy !

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s