I am not doing anything else. I am just making a duplicate of the sheet and
changing the name. Could a virus have done that? I had the same issue with
another document as well. Have you ever heard of this happening before? Is
there anything that could make this happen?
--
dcdus


"Gord Dibben" wrote:

I would say you are doing something else to make the rows disappear before
you copy the sheet.

Go back over all your steps prior to copying the sheet.

Any filtering, copying etc. being done?


Gord Dibben MS Excel MVP

On Sun, 13 Sep 2009 10:26:01 -0700, dcdus
wrote:

I select the sheet at the bottom and right click and then copy it and then it
creates a second copy. I then rename it. I would say that missing rows has
happened a few times over the past four or five years but it's only missed
one or two rows. This time it missed about 40 rows (and, again, they were
disbursed). The problem is, the file is a list of advertisers in a
publications. So, when the rows get lost, the paid advertisers no longer get
the ads that they reserved. It's a problem because I didn't know they were
missing until I was looking for one of the advertisers and couldn't find
them. Then I compared that sheet to the one that I sent my editor and I
found that I was missing several files.