after creating a copy of a sheet, several rows missing (not hidden

[dcdus]

Every month I copy the monthly sheet (i.e. September) and then create a new
sheet (i.e. October). I then do all changes that need to be made. However,
when I copied the September over and renamed it October, about sixty rows
were missing. They were not consecutive rows and they were not hidden. They
just disappeared.

I am not sure what happened to them and how to make sure that it doesn't
happen again. Fortunately, my editor had the correct version but I still had
several hours worth of work trying to duplicate the October sheet correctly.
This happened to two different files. Can anyone tell me what could have
possibly happened and how to fix it?

 

[dlw]

Tell us the exact steps you go through to do the copy and we can guess at
what went wrong.

 

[dcdus]

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.

 

[Gord Dibben]

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

 

[dcdus]

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?

 

[dlw]

are the missing rows blank, or just gone? if they are just gone, right after
the copy, look at the last row and see if the number matches.

 

[Gord Dibben]

I have not heard of it happening when you copy the entire sheet as you
described.


Gord

 

[dcdus]

So, do you know of anything I should look at to try to fix it? Could it have
been caused by a virus?

 

[Gord Dibben]

Does it happen every time you copy any sheet by right-click>move or
copy>create a copy?

Does it happen with new workbooks and sheets or just existing ones?

I have not heard of a virus specific to Excel that would delete rows from
copied sheets.

When you open the workbook do you get a macro warning?


Gord

 

[dcdus]

nope...no warning.

Okay, so now I have another major issue. I just switched from pc to mac and
I am trying to open a document but it seemed to have reformatted itself so
now it's four pages instead of one. Is this common? What can I do about it?
Thanks, Diane

 

[Gord Dibben]

Same printer driver or different driver?

BTW.........you neglected to answer a few questions I posted in previous
reply.


Gord

 

[dcdus]

There is no macro warning. It does not happen every time. It happens with
the file that I have been using for a long time. And, I am using the same
printer and same printer driver. When I preview, it shows part of the file
being cut off.