Office97 security risk

[medric2]

I've been using Office97 for several years now and have not noticed this "feature" until now.
I have an Excel workbook with a few worksheets, one of which contains a graph.
If I highlight the graph and "copy" and then launch a Word97 document and "Paste" (not linking)I get the graph in the word document as expected. If I then double click the graph I can view all of the worksheets in the original workbook.
I am amazed at this as there could be confidential information in the rest of the workbook which I don't want anyone else to see.
Why does it paste the whole workbook when I only highlighted and copied the graph? Shouldn't it warn me that it's pasting the whole book?
I realise that if I "paste special" and choose picture this gets round the problem but how many people realise this?
Dave

 

[tf1]

You have the default paste setting to paste/Link. When you double-click on the pasted WS, it opens Excel so that you can edit it. You should be able to break the link by selecting the WS in Word and using Ctrl+Shift+F9.


Regards: tf1

 

[medric2]

Hi tf1 and thanks for the reply. It isn't a link that I've inadvertently created the whole workbook is embedded in the Word file.
I can mail the Word file to someone who does not have access to the original Excel file and they can still double click the chart and get access to all of the other worksheets in the original file.