I have a workbook with 4 tables. I have added these tables to Power Pivot in which I'm performing a number of calculations, both calculated column and measures.
The workbook worked just fine when I was creating the model, added calculation and so forth. When doing this I did not change any content of the source tables.
However, when I was happy with the calculations in the model I added a row in one of the source tables, I then hit the "updated all" button in the Power Pivot ribbon and got the message "Errors in Linked Tables" with the only options to Do nothing, Change Excel table Name, Remove link to excel table or Delete PowerPivot Table!
All the linked tables are updated except the one where a added a row! If I remove the added row again and hit "update all" it works fine! If I only change the values in the "original" row and hit "update all" it works fine!
What might be causing this? To me it dosn't seems to be related to the way I created the model or the type of data in the source tables.