Hi all,

I cannot find a way to move/copy/duplicate PowerView worksheets/reports inside the same workbook.

It happens I create a second PowerView report and then I decide to have it as the first one... couldn't find a way!

Thank you,

Roberto

Insert New Power View, select objects from first Power View with Ctrl +A and copy the selection  in the new Power View.

Insert New Power View, select objects from first Power View with Ctrl +A and copy the selection  in the new Power View.

Thank you for your suggestion. I had already tried this way but when pasted in the new worksheet the objects don't keep their location and I have to place them correctly again. Any other idea? Roberto

• Edited by roberto.franco 16 hours 46 minutes ago

Thank you for your suggestion. I had already tried this way but when pasted in the new worksheet the objects don't keep their location and I have to place them correctly again. Any other idea? Roberto

• Edited by roberto.franco Friday, April 04, 2014 6:15 PM

Thank you for your suggestion. I had already tried this way but when pasted in the new worksheet the objects don't keep their location and I have to place them correctly again. Any other idea? Roberto

• Edited by roberto.franco Friday, April 04, 2014 6:15 PM

Hello Roberto,

It seems that the Move & Copy option is not available for power View sheet. I have no solution for this issue ,but you can try the following workaround:
1.Open a blank workbook, go to File->Options->Add-Ins->COM Add-ins->Go->Disable Power View and PowerPivot Add-in
2.Open your Workbook containing Power View reports, you can use the 'Move or Copy' option to resort  Power View reports, then enable these add-ins.
Hope this will be improved in the next version of Excel.

Wind Zhang
TechNet Community Support

Hello Roberto,

It seems that the Move & Copy option is not available for power View sheet. I have no solution for this issue ,but you can try the following workaround:
1.Open a blank workbook, go to File->Options->Add-Ins->COM Add-ins->Go->Disable Power View and PowerPivot Add-in
2.Open your Workbook containing Power View reports, you can use the 'Move or Copy' option to resort  Power View reports, then enable these add-ins.
Hope this will be improved in the next version of Excel.

Wind Zhang
TechNet Community Support

• Marked as answer by Wind Zhang CHNMicrosoft contingent staff, Moderator 9 hours 39 minutes ago

Thank you it works! Now I'm missing a way to fully copy a power view slide. Roberto