Deleting worksheets

[Guest]

What is the best way to erase a worksheet, it shouldn't
leave any trace - whats so ever - on the hard drive

 

[icestationzbra]

one of the ways that i have found useful is to clear all the contents o
the sheet. save the sheet. then delete it

 

[Gord Dibben]

Cannot be done without third-party assistance.

http://www.accessdata.com/Product07_Overview.htm?ProductNum=07

Gord Dibben Excel MVP

 

[Guest]

Thanks... But this is only good when you want to delet the
entire hard drive, & I am only looking only for some
worksheets/books to be deleted.

 

[Frank Kabel]

Hi
create a new workbook and copy only the required sheets to this new
workbook

 

[Lady Layla]

Unfortunately the only way for you to do what you want to do --- totally wipe it
off, is to totally wipe your HD. Unless something like this is done, there is
the chance that the data can be recovered.


: Thanks... But this is only good when you want to delet the
: entire hard drive, & I am only looking only for some
: worksheets/books to be deleted.
: >-----Original Message-----
: >Cannot be done without third-party assistance.
: >
: >http://www.accessdata.com/Product07_Overview.htm?
: ProductNum=07
: >
: >Gord Dibben Excel MVP
: >
: >On Mon, 20 Sep 2004 06:42:58 -0700,
: <[email protected]>
: >wrote:
: >
: >>What is the best way to erase a worksheet, it shouldn't
: >>leave any trace - whats so ever - on the hard drive
: >
: >.
: >

 

[icestationzbra]

if you get into the technicality of it, a defragment operation performe
on a HDD after a critical deletion, ensures that whatever sectors ha
that file's data written on them, would now be cleansed and the fre
space allocated back for other files to access. at this point in time
the sectors would be 'memoryless' so to speak.

ofcourse, there are very-high-end tools which can retrieve files up t
7 consecutive format operations. format is a higher level operatio
than defragment. but, to cover yourself against them would be a
overkill, unless you are working for department of defence. in an
regular company, i think a defragment operation would be good enough

 

[Gord Dibben]

You asked for "any traces - whatsoever" to be wiped.

I gave you the only sure method.

Deletion of worksheets/books only leave "traces" on the hard drive which can
be found by any file decent file recovery program.

Others have posted solutions that will leave traces.

How far you want to go is up to you.

Gord

 

[Gord Dibben]

I agree with the defrag for "normal" wiping, which should be sufficient for
the OP's needs.

Actually, there are third-party utilities that can wipe unused areas clean
without having to re-format and lose used areas.

Search the net for one if more than a defrag is required.

Gord