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

Article translations Article translations
Article ID: 2758393 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

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.

Cause

This issue occurs because the PowerPivot engine cannot interpret the localized date format.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Workaround

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.

Properties

Article ID: 2758393 - Last Review: November 19, 2012 - Revision: 2.0
Applies to
  • 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
Keywords: 
kbtshoot kbsurveynew kbexpertiseadvanced KB2758393

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com