Data keeps getting corrupted.... URGENT HELP NEEDED!!!
 

could it be following:


you're inserting/deleting CELLS?.
BUT
you haven't selected an ENTIRE row or column.

if you do that the cells below the selected cell get shifted down and
your "records" get corrupted.

Make sure that BEFORE you insert or delete rows/columns, either manually
or with VBA you select entire rows (shift-space) or entire columns (ctrl
space)

if you do it via VBA..
THIS is what HELP says.. please note what they say about the shift
parameter...



Insert Method
See Also Applies To Example Specifics
Insert method as it applies to the Range object.

Inserts a cell or a range of cells into the worksheet or macro sheet and
shifts other cells away to make space.

expression.Insert(Shift, CopyOrigin)

expression Required. An expression that returns a Range object.

Shift Optional Variant. Specifies which way to shift the cells. Can be
one of the following XlInsertShiftDirection constants: xlShiftToRight or
xlShiftDown. If this argument is omitted, Microsoft Excel decides based
on the shape of the range.

CopyOrigin Optional Variant. The copy origin.



Hope this is it.. can't undo the existing corruption, but at least you
can avoid it in future...


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bruccce" wrote:

I have a spreadsheet that I keep getting info from different rows on
to the wrong rows. This has happened several times.
I first thought (and I really try to be very careful not to do this!)
that I sorted some of the rows with out including all of the rows. I
always try to click on the upper left hand square before doing any
sort!

What can I do to prevent this data corruption, or make it so I can
recover my data?
I am thinking about a extra spreadsheet and anytime the data is
changed in a row, that the whole row be copied to this spreadsheet.
Would this work? any other ideas?

I have just lost about 9 days worth of calls (about 7 hours a day) due
to this corruption. I do have some backups, but I don't know when the
data got corrupted.

HELP!
Thanks
Bruce

Data keeps getting corrupted.... URGENT HELP NEEDED!!!
 

do you run macros on your sheet..?
if so ..please post your code so we can help you.

this NG is about programming excel not just using it..

data doesnt get corrupted by itself, without further info it's a bit
hard to guess.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bruccce" wrote:

Unfortunately (sp?), this is not the issue....
I very rarely delete, and I always insert at the bottom. When I do
delete, I always click on the row...


Thanks,
Bruce
"keepitcool" wrote in message
...

could it be following:


you're inserting/deleting CELLS?.
BUT
you haven't selected an ENTIRE row or column.

if you do that the cells below the selected cell get shifted down and
your "records" get corrupted.

Make sure that BEFORE you insert or delete rows/columns, either
manually or with VBA you select entire rows (shift-space) or entire
columns (ctrl space)

if you do it via VBA..
THIS is what HELP says.. please note what they say about the shift
parameter...



Insert Method
See Also Applies To Example Specifics
Insert method as it applies to the Range object.

Inserts a cell or a range of cells into the worksheet or macro sheet
and shifts other cells away to make space.

expression.Insert(Shift, CopyOrigin)

expression Required. An expression that returns a Range object.

Shift Optional Variant. Specifies which way to shift the cells. Can
be one of the following XlInsertShiftDirection constants:
xlShiftToRight or xlShiftDown. If this argument is omitted, Microsoft
Excel decides based on the shape of the range.

CopyOrigin Optional Variant. The copy origin.



Hope this is it.. can't undo the existing corruption, but at least
you can avoid it in future...


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bruccce" wrote:

I have a spreadsheet that I keep getting info from different rows
on to the wrong rows. This has happened several times.
I first thought (and I really try to be very careful not to do
this!) that I sorted some of the rows with out including all of the
rows. I always try to click on the upper left hand square before
doing any sort!

What can I do to prevent this data corruption, or make it so I can
recover my data?
I am thinking about a extra spreadsheet and anytime the data is
changed in a row, that the whole row be copied to this spreadsheet.
Would this work? any other ideas?

I have just lost about 9 days worth of calls (about 7 hours a day)
due to this corruption. I do have some backups, but I don't know
when the data got corrupted.

HELP!
Thanks
Bruce

Data keeps getting corrupted.... URGENT HELP NEEDED!!!
 

Main reason I posted to THIS NG was to see if there was a logical/feasible
way to create a rollback or history log or something. something that when I
change my data, it would get logged into a diff. worksheet. That way I could
always recreate the data.

It looks like we might have found the cuase of the issue. I do sort my data
(seems like this might not be the best thing to do) and some times, I clear
the contents of one or two of the columns. It appears that Excel does not
sort any of the stuff past an empty column??!! Excel does do some WIERD
things!


Any idea how hard it would be to migrate some of my custom code to ACCESS? I
think I might of had my fill with all of these weird issues!

Thanks,
Bruce


"keepitcool" wrote in message
...

do you run macros on your sheet..?
if so ..please post your code so we can help you.

this NG is about programming excel not just using it..

data doesnt get corrupted by itself, without further info it's a bit
hard to guess.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bruccce" wrote:

Unfortunately (sp?), this is not the issue....
I very rarely delete, and I always insert at the bottom. When I do
delete, I always click on the row...


Thanks,
Bruce
"keepitcool" wrote in message
...

could it be following:


you're inserting/deleting CELLS?.
BUT
you haven't selected an ENTIRE row or column.

if you do that the cells below the selected cell get shifted down and
your "records" get corrupted.

Make sure that BEFORE you insert or delete rows/columns, either
manually or with VBA you select entire rows (shift-space) or entire
columns (ctrl space)

if you do it via VBA..
THIS is what HELP says.. please note what they say about the shift
parameter...



Insert Method
See Also Applies To Example Specifics
Insert method as it applies to the Range object.

Inserts a cell or a range of cells into the worksheet or macro sheet
and shifts other cells away to make space.

expression.Insert(Shift, CopyOrigin)

expression Required. An expression that returns a Range object.

Shift Optional Variant. Specifies which way to shift the cells. Can
be one of the following XlInsertShiftDirection constants:
xlShiftToRight or xlShiftDown. If this argument is omitted, Microsoft
Excel decides based on the shape of the range.

CopyOrigin Optional Variant. The copy origin.



Hope this is it.. can't undo the existing corruption, but at least
you can avoid it in future...


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bruccce" wrote:

I have a spreadsheet that I keep getting info from different rows
on to the wrong rows. This has happened several times.
I first thought (and I really try to be very careful not to do
this!) that I sorted some of the rows with out including all of the
rows. I always try to click on the upper left hand square before
doing any sort!

What can I do to prevent this data corruption, or make it so I can
recover my data?
I am thinking about a extra spreadsheet and anytime the data is
changed in a row, that the whole row be copied to this spreadsheet.
Would this work? any other ideas?

I have just lost about 9 days worth of calls (about 7 hours a day)
due to this corruption. I do have some backups, but I don't know
when the data got corrupted.

HELP!
Thanks
Bruce

Data keeps getting corrupted.... URGENT HELP NEEDED!!!
 

Sorting is ok:

and you can have empty columns.. just remember to ALWAYS keep a dummy
header in the first row.

a sheet is not by defintion an access table... you can have mnay
"tables" on a sheet.. which many of us find very usefull

when you sort Excel uses the CurrentRegion method (ctrl+*) to determine
the "list" it's working with.


there IS the UNDO options.. and it has quite a few steps. HAD you
checked your data you COULD have pressed ctrlZ after the sort and you'd
have had no problems.

it's not weird behaviour on Excel's part, it's your inexperience.

about migrating to access.. importing the data will take 5 secs, but
you'll probably have to rewrite quite a bit of your code...
and have to deal with the quirks of access :)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Bruccce" wrote:

Main reason I posted to THIS NG was to see if there was a
logical/feasible way to create a rollback or history log or something.
something that when I change my data, it would get logged into a diff.
worksheet. That way I could always recreate the data.

It looks like we might have found the cuase of the issue. I do sort my
data (seems like this might not be the best thing to do) and some
times, I clear the contents of one or two of the columns. It appears
that Excel does not sort any of the stuff past an empty column??!!
Excel does do some WIERD things!


Any idea how hard it would be to migrate some of my custom code to
ACCESS? I think I might of had my fill with all of these weird issues!

Thanks,
Bruce