Microsoft Office Tutorials and References
In Depth Information
If you continue creating a linked table this way, you cannot update the OrderDate table
anymore. If you create a model that must be refreshed over time and that is likely to have
a life cycle longer than the current year, you are better off using another way, which allows
The second option requires you to copy and paste the existing Calendar table in Excel. Before
you do that, you should rename the Calendar table in Excel, using the same name we used
for the corresponding linked table in PowerPivot, which is OrderDate. To do that, you can
type the OrderDate name into the Table Name text box available on the Design tab of the
Table Tools contextual tab of the Excel ribbon, as you can see in Figure 7-12.
FIguRE 7-12 Renaming the table OrderDate, in Excel.
At this point, if you try to Update the OrderDate linked table in PowerPivot, you get the error
message shown in Figure 7-13.
FIguRE 7-13 The error message you get when you try to update OrderDate after changing the name of the
underlying Excel table.
When you click the Options button, you can select the Change Excel Table Name option.
Then you choose the OrderDate table in the combo box that shows the available tables in
Excel, as you can see in Figure 7-14.