Excel opens duplicate worksheet

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Hi,

I am using Office XP.

I have a problem when opening a certain excel file. When
I open it opens 2 instances of the same file putting at
the end of the filename in the title bar :1 and :2.

This doesn't happen with any other file.

Thanks in advance

Matt
 
Hi Matt!

Excel stores the way you had the file before you saved it last. It
obviously had multiple windows and will have multiple windows when you
open it up next time.

Click in the window you don't want and hit ctrl-F4.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Norman,

thanks for replying, I tried that but it closes both the
windows together.

Matt
 
it closes both the windows together.


Odd. What you "should" see: Start a new Excel. Note you see "Book1". Now
do a Windows, New Window. Note that you now have Book1:1 and Book1:2 (Two
windows to look at the same sheet). Now click the "x" of "Book1:2". You
should be left with just "Book1", the ":1" disappearing.

--
Jim Rech
Excel MVP
| Hi Norman,
|
| thanks for replying, I tried that but it closes both the
| windows together.
|
| Matt
|
|
| >-----Original Message-----
| >Hi Matt!
| >
| >Excel stores the way you had the file before you saved
| it last. It
| >obviously had multiple windows and will have multiple
| windows when you
| >open it up next time.
| >
| >Click in the window you don't want and hit ctrl-F4.
| >
| >
| >--
| >Regards
| >Norman Harker MVP (Excel)
| >Sydney, Australia
| >[email protected]
| >Excel and Word Function Lists (Classifications, Syntax
| and Arguments)
| >available free to good homes.
| message
| >| >> Hi,
| >>
| >> I am using Office XP.
| >>
| >> I have a problem when opening a certain excel file.
| When
| >> I open it opens 2 instances of the same file putting at
| >> the end of the filename in the title bar :1 and :2.
| >>
| >> This doesn't happen with any other file.
| >>
| >> Thanks in advance
| >>
| >> Matt
| >>
| >>
| >
| >
| >.
| >
 
thats great, sorted. Thanks

-----Original Message-----


Odd. What you "should" see: Start a new Excel. Note you see "Book1". Now
do a Windows, New Window. Note that you now have Book1:1 and Book1:2 (Two
windows to look at the same sheet). Now click the "x" of "Book1:2". You
should be left with just "Book1", the ":1" disappearing.

--
Jim Rech
Excel MVP
| Hi Norman,
|
| thanks for replying, I tried that but it closes both the
| windows together.
|
| Matt
|
|
| >-----Original Message-----
| >Hi Matt!
| >
| >Excel stores the way you had the file before you saved
| it last. It
| >obviously had multiple windows and will have multiple
| windows when you
| >open it up next time.
| >
| >Click in the window you don't want and hit ctrl-F4.
| >
| >
| >--
| >Regards
| >Norman Harker MVP (Excel)
| >Sydney, Australia
| >[email protected]
| >Excel and Word Function Lists (Classifications, Syntax
| and Arguments)
| >available free to good homes.
| message
| >| >> Hi,
| >>
| >> I am using Office XP.
| >>
| >> I have a problem when opening a certain excel file.
| When
| >> I open it opens 2 instances of the same file putting at
| >> the end of the filename in the title bar :1 and :2.
| >>
| >> This doesn't happen with any other file.
| >>
| >> Thanks in advance
| >>
| >> Matt
| >>
| >>
| >
| >
| >.
| >


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top