• Excel Book Excerpt

Excel Why Can’t I Edit Data in PowerPivot?

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Why Can’t I Edit Data in PowerPivot?

Problem: I can’t seem to edit data in PowerPivot.

Strategy: This is correct. You can not edit a cell in PowerPivot. If you have a linked table, you can go back to Excel, change the data there. Then, click the Update All icon in the PowerPivot tab of the Excel ribbon.

LE10000997.jpg 

Figure 951 After editing data in an Excel linked table, click Update All.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: