Excel anomoly

  • Thread starter Thread starter Danny Sanders
  • Start date Start date
D

Danny Sanders

Got a user here that has been maintaining an excel XP spread sheet for a few
years. It is just a list of names, addresses, phone numbers, etc for a Gala
that gets added to periodically.

This list has grown to over 3,000 names. She has recently noticed that there
is a sheet 2 associated with sheet 1 in the excel workbook that should not
be there. The sheet 2 has data dispersed through out the sheet. It is not
exactly the same as sheet one in fact I would guess it has about 1/3 the
data that sheet one has.

Highlight row 3151 on sheet 2 to delete it and the corresponding info on row
3151 sheet 1 gets deleted. Highlight sheet two to delete the entire un
needed sheet and ALL the data on sheet 1 gets deleted also.

Selecting the entire sheet 1, copying and pasting sheet one into a new Excel
document results in sheet 1 and 2 being copied into the new document.

How can I delete sheet 2 without affecting sheet 1?
How can I make sure sheet one doesn't get tied to sheet two again?

TIA
DDS
 
Danny,

SOunds like the sheet or workbook is damaged. The following is presuming
there are no formulas anywhere. Instead of pasting to another sheet (in
another workbook), try Paste special - Values. Or try saving it as csv,
then reopen. You can then save that as a regular xls and continue working
with it.

Keep a backup of this workbook, if it's important. Stuff happens.
 
Hi

is it possible the sheets are grouped? - to check, right mouse click on the
sheet tab and choose ungroup sheets - if available.

Cheers
JulieD
 
is it possible the sheets are grouped? - to check, right mouse click on
the sheet tab and choose ungroup sheets - if available.
Click to expand...


That was it.

Thanks JulieD

DDS
 
Back
Top