Hi All,
When I open a normal workbook (without VBA) a second, same workbook
opens automaticly. Named xls:2.
How can I get rid off this?? Has it something to do with my settings?
Usually it works fine.
Regards Berry
RichardSchollar - 10 Jan 2008 08:54 GMT
Hi Berry
What you've done is saved down the workbook with two windows open
viewing this workbook. Simply close one of them (hit the cross in the
top right of the window) and then save the workbook down. On
reopening you should only have the one window now.
Best regards
Richard
> Hi All,
>
[quoted text clipped - 4 lines]
>
> Regards Berry
papou - 10 Jan 2008 08:57 GMT
Hi
You have made two windows of the same workbook.
Click on the second upper right "x" button from the top of the Excel Window
(the one immediately under the bigger "X" button that closes Excel).
Save your workbook.
HTH
Cordially
Pascal
> Hi All,
>
[quoted text clipped - 4 lines]
>
> Regards Berry
Dave Peterson - 10 Jan 2008 14:52 GMT
It's actually two different windows or views into the same workbook.
Select the window you don't want and hit ctrl-w.
Then save the workbook--or you'll be doing it again.
Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows
> Hi All,
>
[quoted text clipped - 4 lines]
>
> Regards Berry

Signature
Dave Peterson