Excel Question

[imadoofus]

Now I consider myself pretty expert at Excel, but....

I've got Excel 2003 (SBE), and when you first open it, you get a blank worksheet, entitled 'Book1'.

When I open a saved worksheet, that 'Book1' should disappear, but it doesn't.

So if I've got three worksheets open, I actually have four.

Why? How do I make it do what I want?

It works properly with Word.

Edit: If I open Excel and then immediately close it again, I get asked if I want to save the changes I made to book1. There is nothign in my XLSTART folder.



TIA

PJ

 

[wallingd]

Hmm curious. Do you launch the 2nd XLS from Explorer or from File | Open? I don't recall any oen that says leave-0orig-book-open or words to that effect... Has it always done this?

 

[imadoofus]

I openend the second file from <File / Open>, but in fact it makes no difference if I open from Explorer; it does the same thing.

I've only had this laptop for about a month, and it's always done it (AFAIK). My version of Office SBE is an upgrade from Office '97, which I didn't run on this machine, just installed it so I could install the u/g, and save some money in the process.

The thing where it asks if I want to save changes reminds me of some virus thing that can affect the normal.dot template in Word, but I'm completely virus-free.

PJ

 

[mobeyone]

Dont you have to close the open (book 1) workbook first? and then open your saved sheet?

Thats what I usually do and only ever have opened the number of sheets i want to look at?

 

[imadoofus]

Dont you have to close the open (book 1) workbook first? and then open your saved sheet?

I never have done before.

 

[mobeyone]

I never have done before.

Wierd.. I always do it this way.. never thought about it before!!!

With the old version of excel, you could do this but I think with the 03 version it defaults to a blank sheet, dont know if you can change that...

 

[imadoofus]

I think I've fixed it....

In Program Files/Microsoft Office/Office11, there's a folder called XLSTART. mine was empty, but some obscure thread on the web suggested it should have 'book.xlt' in it.

So I opened Excel, saved 'book1.xls' as 'book.xlt' in that folder, and it made not difference at all.

So I deleted 'book.xlt' and the problem's gone!



Thanks for your time anyway, guys.

PJ

PS: mobeyone, you don't have to clsoe Book1. When you open a saved filer, book1 disappears anyway.

 

[Bobby Dazzler]

When I open a saved worksheet, that 'Book1' should disappear, but it doesn't.

So if I've got three worksheets open, I actually have four.

PJ - So after you've opened your saved worksheets do you still see Book 1 in the Window menu (shown below), even after you've opened any other worksheets?

View attachment 6213

 

[imadoofus]

PJ - So after you've opened your saved worksheets do you still see Book 1 in the Window menu (shown below), even after you've opened any other worksheets?

Yes, I did, but now I don't :bannana: (see above)

 

[wallingd]

Microsoft...