Copying a pivot table
Many times I want to "take a picture" of a pivot table and send it to someone who isn't well trained in Excel so I just want them to have the information summary without being able to change the table or see the underlying data.
In prior versions of excel you could copy and paste the contents of a pivot table to another sheet or workbook and it would either retain all formating or you could "paste/special/formats" to get the format from the original table applied to the copy.
I can no longer get that to happen with Excel 2007.
Can anyone help me out?
Solutions to the Problem Copying a pivot table
On the Home tab, there will be a Group on the extreme left called clipboard.
Click on the little square at the bottom right of the Clipboard. When you do so, on the left pane, the clipboard box will appear
Now select the pivot table and copy it
Select any blank cell
On the clipboard on the left hand side, the copied data will appear. Just click on the entry.
You will notice that the data along with the formatting will get copied and it will just be an image.
Hope this helps.
Do let me know how this works.
Use the System File Checker tool to repair corrupted or missing system files:
- Click Start.
- Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
- The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
- Type or copy paste the below command line into it without quotes:
- "Sfc /scannow"
Another Safe way to Fix the Problem: Copying a pivot table:
How to Fix Copying a pivot table with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will perform a scan for your system. The junk files will be shown in the list.
2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.
3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.
Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.220.127.116.1186,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.18.104.22.1680,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.22.214.171.1249,Method to Update & Download ASUS K41VD Intel INF Update Driver v.126.96.36.1995,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Fast Solution to Error: Connections,Troubleshoot:Converting data from one row to one column,Convert cells (pasted from another application) to date format [Solved],Troubleshoot:Copy and pasteing from one web page to another.,Fast Solution to Error: Create Process Error when run a CD from Casio,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly