Pivot Table - Issue with Copy, paste special value over existing Pivot

absolute

New Member
Joined
Sep 16, 2009
Messages
5
Hi,
Prior to today (WED 08/23/17) if I had a worksheet with a pivot table on it, formatted, etc, and wanted to email it out w/o the pivot functions, I could highlight the entire worksheet (click corner button to the left of A, and above 1), Ctl+C, right-click in cell A1, then Paste-Special Values. It would remove the pivot function, but keep all formatting (borders, # formats, column widths, wrapped text, etc) allowing me to delete out the source data tab to keep the file very small, and not allow the user to manipulate.

I'm using Windows 10, Excel 2016. This morning I received some type of App update (Outlook, Skype, Excel) and since then, it will not allow me to copy, paste-special values and keep my formats. it will copy, paste-special, but then I lose all the formatting associated within the pivot table. It won't allow me to paste-special formats after that?

I can copy & paste-special values, then paste-special formats to a new worksheet, but then I have to reformat all my page settings, delete out the other tabs, and rename the new tabs. Has anyone had this issue come up? Any fixes?

I have several tabs w/i workbooks that I do this with daily so I can email out reports to groups of people, so having to do page formatting & naming of tabs for each sheet would be very time consuming for me.

Thank you!
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,021
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top