Forum

All tables in an Ex...
 
Notifications
Clear all

All tables in an Excel sheet do not load when I "Add to Data Model" in Power Pivot

2 Posts
2 Users
0 Reactions
97 Views
(@fancity)
Posts: 1
New Member
Topic starter
 

Hi,

Ref "Excel file pp_6.03_before", exercise file in Power Pivot course.

The Sheet1 tab has three excel tables i.e. 1) Sales 2) Costs and 3) Regions

When I go to Power Pivot --> Add to Data Model -->

It loads only two tables, i.e Sales and Costs

It does not load the Regions table.

What could be the reason?

What am I doing wrong?

Thanks,

Ajith

 
Posted : 16/05/2021 3:43 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Ajith,

Not sure why it's not loading for you. I was able to load it. See file attached.

Mynda

 
Posted : 16/05/2021 3:59 am
Share: