Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have a problem in Excell 2000 for the last 3 -4days. Whenever I open a sheet and make any changes in the sheet it copies and opens a seperate sheet with the name of that sheet and ":1" or ":2" in the end of that sheet name. If I save this sheet and reopen then both sheets are opend automatically e.g. sheetname:1 and sheetname:2. I don't know what is the problem or is there any option selected wrongly. Anyone knows how to fix it? It will be highly appriciated., Thanks in anticipation. A.Hameed |
#2
![]() |
|||
|
|||
![]()
This is just another window for that workbook. Just close the :1, :2 copies,
that will cure it. -- HTH RP (remove nothere from the email address if mailing direct) "Abdul Hameed" wrote in message ... Hi, I have a problem in Excell 2000 for the last 3 -4days. Whenever I open a sheet and make any changes in the sheet it copies and opens a seperate sheet with the name of that sheet and ":1" or ":2" in the end of that sheet name. If I save this sheet and reopen then both sheets are opend automatically e.g. sheetname:1 and sheetname:2. I don't know what is the problem or is there any option selected wrongly. Anyone knows how to fix it? It will be highly appriciated., Thanks in anticipation. A.Hameed |
#3
![]() |
|||
|
|||
![]()
Don't forget to <Save after you've closed the copies (no more :#'s in the
title bar), otherwise they'll all come back when you re-open the WB. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Bob Phillips" wrote in message ... This is just another window for that workbook. Just close the :1, :2 copies, that will cure it. -- HTH RP (remove nothere from the email address if mailing direct) "Abdul Hameed" wrote in message ... Hi, I have a problem in Excell 2000 for the last 3 -4days. Whenever I open a sheet and make any changes in the sheet it copies and opens a seperate sheet with the name of that sheet and ":1" or ":2" in the end of that sheet name. If I save this sheet and reopen then both sheets are opend automatically e.g. sheetname:1 and sheetname:2. I don't know what is the problem or is there any option selected wrongly. Anyone knows how to fix it? It will be highly appriciated., Thanks in anticipation. A.Hameed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |