Excel opens duplicate worksheet

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
 
N

Norman Harker

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.
 
M

Matt

Hi Norman,

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

Matt
 
J

Jim Rech

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
| >>
| >>
| >
| >
| >.
| >
 
M

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
| >>
| >>
| >
| >
| >.
| >


.
 
Top