Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Excel 2002 - Opens two files of the same name

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Greg C - 23 Jan 2008 01:46 GMT
When I open a one of my files it opens two files of the same name but with a
different number on the end. E.G. the file name is "Past Players:1" and the
other file name is Past Player:2, the original name is Past Players without
the number.  
At the moment I have downloaded the trial of 2007 where the problem has been
fixed, but at the end of the trial I don't want to pay for 2007 as I am a
pensioner and can't afford the upgrade.
Bernard Liengme - 23 Jan 2008 02:00 GMT
You have somehow enable a New Window view.
In XL 2003 this if done with Window | New Window
In XL2007 it is done with New Window on the View tab of the Ribbon
This feature lets you, for example, look at two sheets of the same workbook
side by side.

Just close one of the views (say Past Players 2) without saving; then save
Pat Players  (the 1 should have gone)

If you are happy with XL2003 stay with it. Xl2007 has some new features but
nothing you cannot live without I expect
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> When I open a one of my files it opens two files of the same name but with
> a
[quoted text clipped - 7 lines]
> fixed, but at the end of the trial I don't want to pay for 2007 as I am a
> pensioner and can't afford the upgrade.
RagDyer - 23 Jan 2008 02:01 GMT
Those suffix numbers indicate that you have multiple windows of the same WB
open.

Do a
<Ctrl> < W >
to close the additional window, and make those numbers disappear.
Now, <Save> the WB.

If you go to,
<Window> <New Window>,
You'll create those duplicate copies of the WB again.

This comes in handy when you wish to see different locations, at the same
time, of the WB.

After you create a "New Window", you go to,
<Window> again, and click <Arrange>

And configure your display of multiple pages.
You can open many new windows to see multiple assorted displays of the WB.
Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> When I open a one of my files it opens two files of the same name but with
> a
[quoted text clipped - 7 lines]
> fixed, but at the end of the trial I don't want to pay for 2007 as I am a
> pensioner and can't afford the upgrade.
Tyro - 23 Jan 2008 02:43 GMT
You have the workbook opened in two windows. That is why you're seeing the 1
and the 2. Simply close one of the windows and save the file.

Tyro

> When I open a one of my files it opens two files of the same name but with
> a
[quoted text clipped - 7 lines]
> fixed, but at the end of the trial I don't want to pay for 2007 as I am a
> pensioner and can't afford the upgrade.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.