Prev: Excel 2007, where are ribbon settings kept?
Next: dd/mm/yy if i change to some other format
From: DaveHawkey on 25 May 2010 05:32

Hi,

I have a workbook which opens with the window title

filename.xls:1

as if there are two or more views of the same workbook. However, there
is only one view I can find (I have minimised the window within Excel,
looked for other Excel windows but to no avail).

When I try to close the file (ctrl-w or clicking the lower x) the
workbook disappears (as expected) but Excel behaves as if I have just
closed one of several views: it doesn't ask me if I would like to save
changes. However, when I close the Excel program, it behaves as if I am
closing filename.xls and asks if I want to save changes. As I work with
a large number of Excel files at any one time, this can become
confusing and could lead to saving stuff that I didn't want to save or
losing changes I have made.

In case it helps, if I set up a new view with Window -> New Window, I
get

filename.xls:3

implying that number 2 is floating around somewhere, I just can't find
it.

Any ideas?

Dave




--
DaveHawkey
From: Dave Peterson on 25 May 2010 09:32
If you don't see that other window (filename.xls:2), then it's either off the
screen or hidden.

I'd try this first, even though I don't think that this is the problem.
Window|Arrange|Tiled
(in xl2003 menus)
to see if it was just off the screen.
(I don't think that this is the problem)

The next thing is to look for hidden windows.
Window|unhide
(in xl2003 menus)
Then maybe tile the windows

And try the ctrl-w stuff to close the window(s) you don't want.

DaveHawkey wrote:
>
> Hi,
>
> I have a workbook which opens with the window title
>
> filename.xls:1
>
> as if there are two or more views of the same workbook. However, there
> is only one view I can find (I have minimised the window within Excel,
> looked for other Excel windows but to no avail).
>
> When I try to close the file (ctrl-w or clicking the lower x) the
> workbook disappears (as expected) but Excel behaves as if I have just
> closed one of several views: it doesn't ask me if I would like to save
> changes. However, when I close the Excel program, it behaves as if I am
> closing filename.xls and asks if I want to save changes. As I work with
> a large number of Excel files at any one time, this can become
> confusing and could lead to saving stuff that I didn't want to save or
> losing changes I have made.
>
> In case it helps, if I set up a new view with Window -> New Window, I
> get
>
> filename.xls:3
>
> implying that number 2 is floating around somewhere, I just can't find
> it.
>
> Any ideas?
>
> Dave
>
> --
> DaveHawkey

--

Dave Peterson
 | 
Pages: 1
Prev: Excel 2007, where are ribbon settings kept?
Next: dd/mm/yy if i change to some other format