You are currently offline, waiting for your internet to reconnect

"Pasting Data Failed" error when you paste HTML-formatted data into PowerPivot

Assume that you want to copy and then paste some data into PowerPivot for Microsoft Excel. The data is in the HTML format, and contains localized date formats. When you try to copy and then paste the data, you receive an error message that resembles the following:
Pasting data failed.
The object does not exist or read permissions are needed.
This issue occurs because the PowerPivot engine cannot interpret the localized date format.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
To work around this issue, use one of the following methods.

Method 1

Do not copy and paste the data directly into PowerPivot. Instead, paste the HTML-formatted data into an Excel Worksheet, and then use the Excel Worksheet as the data source of the PowerPivot data model.

Note The data is pasted as string type, and cannot be converted to date type.

Method 2

Use the English (United States) date format as the localized date format.

Article ID: 2758393 - Last Review: 11/19/2012 19:09:00 - Revision: 2.0

  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010
  • kbtshoot kbsurveynew kbexpertiseadvanced KB2758393