Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Abdul Hameed
 
Posts: n/a
Default Sheet Duplication

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
RagDyeR
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make an excel worksheet (sheet 2) open w/ the cursor located in t. animated text in excel worksheet Excel Discussion (Misc queries) 0 February 10th 05 10:29 PM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. RonMc5 Excel Discussion (Misc queries) 9 February 3rd 05 12:51 AM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"