PowerPivot: Pasting Data Failed

Question

I am running Excel 2016. I have been using powerpivot for over a year -- adding around 8,000 rows to the data model using "paste append" once a quarter. Today, when I tried adding additional rows, I got the following error. Note: I also tried creating a new excel file with a new data model and got the same error when I tried using the "paste append" function.

Please help!!

============================

Error Message:

============================

The given key was not present in the dictionary.

---

Pasting data failed.

============================

Call Stack:

============================

   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

   at Microsoft.AnalysisServices.BackEnd.PushedDataTable.ReorderColumns(Object[][] data, List1 oldColumnOrder, Dictionary2 columnOrderMap)

   at Microsoft.AnalysisServices.BackEnd.PushedDataTableImplAmo.PushData(Dimension dimension, PushedDataSource pushedDataSource, PushedDataInfo pushedDataInfo, Dictionary`2 columnOrderMap)

   at Microsoft.AnalysisServices.BackEnd.PushedDataTableImplAmo.PushData(DataModelingTable table, PushedDataSource pushedDataSource, PushedDataInfo pushedDataInfo, Dictionary`2 newColumnOrderMap)

   at Microsoft.AnalysisServices.BackEnd.PushedDataTable.PasteAppendReplaceTable(DataModelingTable table, String htmlContent, Boolean useExcelFormat, Boolean firstRowAsHeaders, Dictionary`2 columnOrderMap, PushedDataInfo pushedDataInfo)

---

   at Microsoft.AnalysisServices.BackEnd.PushedDataTable.PasteAppendReplaceTable(DataModelingTable table, String htmlContent, Boolean useExcelFormat, Boolean firstRowAsHeaders, Dictionary`2 columnOrderMap, PushedDataInfo pushedDataInfo)

   at Microsoft.AnalysisServices.BackEnd.PushedDataTable.PasteAppendTable(DataModelingTable table, String htmlContent, Boolean useExcelFormat, Boolean firstRowAsHeaders, Dictionary`2 columnOrderMap)

   at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.PasteAppendTable(DataModelingTable table, String htmlContent, Boolean useExcelFormat, Boolean firstRowAsHeaders, Dictionary`2 columnOrderMap)

   at Microsoft.AnalysisServices.Common.SandboxEditor.PasteTable(String htmlContent, Boolean useExcelFormat, Boolean firstRowAsHeaders, Dictionary`2 columnOrderMap, DataModelingTable table)

   at Microsoft.AnalysisServices.Common.SandboxEditor.PasteAppendClipboardData(String htmlContent, Boolean useExcelFormat)

============================

Answer 1

One of my columns had an unacceptable symbol "/". Even though it allowed me to create the header and append rows of data for the past year, it stopped working (guessing there was an updated in the last few months that "fixed" the program from allowing the special character to be used in the first place). I tried removing the character from the column heading, but it still wouldn't work. Instead, I had to recreate my entire powerpivot (with lots of calculated fields) from scratch, leaving out the special character, for it to work again.

Answer 2

Hi,

Since the issues is related to Power Pivot you may post your query in Excel IT Pro forum for better results.

You may refer to the below link to redirect to Excel IT Pro Forum.

http://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

If you have further questions related to this, please let us know.

Thank you.