Pivot Table Cell Link to Database of Information

shuval

New Member
Joined
Sep 27, 2010
Messages
1
Currently, we have a Excel spreadsheet in which a tab contains a database like of information (both sensitive & non-sensitive) on a particular topic. From this database, we devleoped Excel's Pivot Table. In order to share that data, we develop a Pivot Table on that same spreadsheet revealing non sensitive informaiotn We made a copy of that spreadsheet and place it on a New Book (i.e. another spreadsheet). We send that new spreadsheet to other via outlook. When the recipient of that email receive and open the attachment, he will simply only see that pivot table as a single tab. However, the recipient can double-click on a figure in that Pivot Table and see the information from the complete database (both sensitive and non-sensitive) informaton. We did not anticipate this action. As a added security measure, we had the original database on a secured subfolder on our network. And yet the recipent was able to see the (what we thought) was secured data. Any helpful hints in preventing the linkage to the original databse of information?
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

Instead of a straight Copy/Paste, which also pastes the PivotCache (and the underlying data), you can use Paste Special-->Values. You'll lose Pivot Table functionality, but if it's just for display then that shouldn't be an issue. If you need to retain the PT functionality there are workarounds, but they involve VBA.

HTH,
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,123,177
Messages
5,600,160
Members
414,367
Latest member
dw970906

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
Top