Share via

Getting error while copying selected excel sheets to new book. "We couldn't get the data from the data model. ..."

Anonymous
2023-12-15T07:05:00+00:00

Getting Error while copying excel sheets from one file to new workbook.

Error message says

"We couldn't get the data from the data model. Here's the error message we got:

Following System error occurred: Type mismatch."

Getting same error whether I choose to copy sheets or move sheets.

The sheets which I am trying to copy / move to new book contains following.

Defined named ranges

Power query

Power pivot tables

Power pivot and power query based charts and slicers

Normal cell range based Charts

Does not contain any macro.

Using Office 365 desktop for business and Wind10 Pro.

Requesting help to resolve the issue.

Edit: Just noticed that If I delete all the slicers from the sheet, it is allowing me to copy / move sheet. Slicers are connected to power piovt table.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-19T10:15:50+00:00

    Thanks for the reply.

    Getting the same error in both the cases i.e. 1. Whether I create copy and move to another book or 2. Move to another book.

    0 comments
  2. Anonymous
    2023-12-19T09:53:47+00:00

    You may try right click your file and use move or copy and create a copy of that sheet.

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2023-12-19T05:38:24+00:00

    Thanks for revert.

    Link to Sample workbook

    Sharing workbook link above.

    I am trying to move Pivot sheet from the file to a new book. Getting the error mentioned in the question and not able to move single 'pivot' sheet to a new book.

    Sorry for delay in response.

    0 comments
  5. Anonymous
    2023-12-15T10:22:28+00:00

    Is it possible to share us a test workbook to reproduce your issue?

    For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

    0 comments