Deleting worksheets

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

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


--
icestationzbra
------------------------------------------------------------------------
icestationzbra's Profile: http://www.excelforum.com/member.php...fo&userid=4580
View this thread: http://www.excelforum.com/showthread...hreadid=261599

Cannot be done without third-party assistance.

http://www.accessdata.com/Product07_...?ProductNum=07

Gord Dibben Excel MVP

On Mon, 20 Sep 2004 06:42:58 -0700,
wrote:

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

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,

wrote:

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

.

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

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.


wrote in message
...
: 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,
:
: wrote:
:
: What is the best way to erase a worksheet, it shouldn't
: leave any trace - whats so ever - on the hard drive
:
: .
:

if you get into the technicality of it, a defragment operation performed
on a HDD after a critical deletion, ensures that whatever sectors had
that file's data written on them, would now be cleansed and the free
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 to
7 consecutive format operations. format is a higher level operation
than defragment. but, to cover yourself against them would be an
overkill, unless you are working for department of defence. in any
regular company, i think a defragment operation would be good enough.


--
icestationzbra
------------------------------------------------------------------------
icestationzbra's Profile: http://www.excelforum.com/member.php...fo&userid=4580
View this thread: http://www.excelforum.com/showthread...hreadid=261599

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

On Mon, 20 Sep 2004 09:48:38 -0700,
wrote:

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,

wrote:

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

.

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

On Mon, 20 Sep 2004 13:01:32 -0500, icestationzbra
wrote:


if you get into the technicality of it, a defragment operation performed
on a HDD after a critical deletion, ensures that whatever sectors had
that file's data written on them, would now be cleansed and the free
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 to
7 consecutive format operations. format is a higher level operation
than defragment. but, to cover yourself against them would be an
overkill, unless you are working for department of defence. in any
regular company, i think a defragment operation would be good enough.