Updating Data in Linked Table

Question

Hello, 

I am having issues adding new data to an existing linked table. The original source data table is contained within the workbook. 

When I try to add new data (copy+paste into original data table), then select "update all" on the power pivot menu, I get an error message:

"There were errors trying to update one or more linked tables.  Use Options below to see ways to fix these problems, or OK to continue without fixing them."

Note that this message is received after ensuring the new data has the same number of columns and the same formatting as the existing data. When I try to copy and paste the data directly into the PowerPivot table, a new table is created rather than updating the existing table.

Please let me know what I can do to resolve this issue. 

Thank you, 

Andrea

Answer 1

Hi Andrea,

Thanks for your question.

For this issue, I would suggest you to refer to a similar thread in blow link:
Excel 2013 Errors in Linked Tables; An Answer

However, when I am trying to add new data (copy+paste into original data table), then select "update all" on the power pivot menu, I did not get this error message. I can get this error message only when I remove data in the one side table for one-to- many relationship. For this error, you can either select the option "Do Nothing" or "Remove link to Excel Table".

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 2

Please kindly mark the correct solutions as answers, this could be beneficial to other community members who are facing similar issue. Your contribution is highly appreciated.

---

https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx