Unable to update Excel Workbook from PowerPivot data - by kiloolik

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 772461 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 11/27/2012 11:52:22 PM
Access Restriction Public


Please, fix problem described here http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/ef2a98e4-5701-476b-ae30-0ca186bc5aa7
Sign in to post a comment.
Posted by Microsoft on 10/25/2013 at 11:39 AM
"Update All" is used to update all PowerPivot tables that are linked to tables in Excel.
If we don't create linked tables in PowerPivot, we will encounter the message "The command cannot be completed. No tables were detected in the active Excel workbook that are linked to PowerPivot tables". This is an expected message.

To verify if you have linked tables, please open the PowerPivot window, and check if there is a Linked Table tab in the PowerPivot window.