#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default file name :2

Hi,

When I open up one excel file such as "Month", then name
at the top of my screen shows "Month:2"

Why is that and how do I get rid of that?

thanks

Carrie
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default file name :2

you have two copies of the same workbook at the same time. Go to the window
menu in excel, select arange and tiled. close one copy of the workbook &
resave
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"carrie" wrote:

Hi,

When I open up one excel file such as "Month", then name
at the top of my screen shows "Month:2"

Why is that and how do I get rid of that?

thanks

Carrie

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 149
Default file name :2

Somewhere along the way you activated WindowsNewWindow ("creating" :1, :2
window views) and then saved the file.

Simply close any extraneous "Month" windows (as indicated by the OpenFile
list under Excel's Windows menu) and re-save the file.

HTH,


"carrie" wrote in message
...
Hi,

When I open up one excel file such as "Month", then name
at the top of my screen shows "Month:2"

Why is that and how do I get rid of that?

thanks

Carrie



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default file name :2

One more...


You actually have two windows open to the same workbook.

Select the one you don't want anymore and hit ctrl-w

Then save the workbook--or you'll be doing it again.

This can be a useful feature if you want to see different parts of the workbook
at the same time.

Window|New window
(to create that second window)

then
Window|Arrange|Horizontal (or the way you like it)




carrie wrote:

Hi,

When I open up one excel file such as "Month", then name
at the top of my screen shows "Month:2"

Why is that and how do I get rid of that?

thanks

Carrie


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default file name :2

Hi,

Troubleshoot workbooks and worksheets

There is a ":1" or ":2" in my workbook title.

You have more than one window open for the active workbook. Switch to the
window you want to close, and then click Close Window in the upper-right
corner of the workbook window.

Note If you save a workbook while more than one window is open and then
close the workbook, the same number of windows will open the next time you
open the workbook. If you want to only one window the next time you open the
workbook, close all but one window before you save and close the workbook

Challa Prabhu

"carrie" wrote:

Hi,

When I open up one excel file such as "Month", then name
at the top of my screen shows "Month:2"

Why is that and how do I get rid of that?

thanks

Carrie

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
File:1 and File:2 -- Double Files when Opening One File dallin Excel Discussion (Misc queries) 1 January 25th 07 02:53 AM
I saved file A over file B. Can I get file B back? Lynn Excel Discussion (Misc queries) 2 May 12th 06 11:24 AM
opening an excel file opens a duplicate file of the same file skm Excel Discussion (Misc queries) 1 December 7th 05 05:52 PM
I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . DUFFER8MCD Excel Discussion (Misc queries) 1 December 23rd 04 11:32 PM
i received a file that reads powerpoint document file file exten. CCAROLACEREC Excel Discussion (Misc queries) 1 December 4th 04 05:02 PM


All times are GMT +1. The time now is 01:17 PM.

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"