Book1 issues

[Guest]

If I open Excel 2003 it opens Book1 (that is normal), then if I make no changes to Book1 and close Excel it asks if I want to save Book1. Normally if you open Book1 and then close Excel it does not ask if you want to save it. Also, if I open Excel 2003 it opens Book1 then I click File, Open and click on an existing .xls file. It keeps Book1 open and you can see this on the taskbar - Book1 and the existing .xls file. Normally if you open Book1 and then open another .xls file it 'closes' Book1 and you don't see it on the taskbar. I have 2 user with Notebooks that have this issue but all of our other users do not see this behavior. HELP!!

 

[Dave Peterson]

I had a similar problem. But my message was: Do you want to save it in the
version?

Turns out that my book.xlt file was saved in an older version. I opened my
book.xlt (and sheet.xlt) template files (in XLStart) and saved them in the newer
version. And all those problems went away.

And newer versions of excel like to recalculate when opening a workbook saved in
an earlier version. If it's been recalculated. So maybe that's the cause?????

 

[Dave Peterson]

Maybe it was in a hidden folder? Are you using WinXP?

If yes, then you can change the search option to search for hidden files in
hidden folders (I think--I don't use winXP).

or you can Shell to a Command prompt and type:

dir c:\*.xlt /s

the /s says to search subfolders.

If that's not it, maybe someone else can jump in with a better answer.

 

[icestationzbra]

if you are looking for hidden files through command prompt, you have go
to use the attrib switch (/ah).

at c:\>, type the following:

dir *.xlt /s /a

 

[Dave Peterson]

Oops. Thanks for the correction.

if you are looking for hidden files through command prompt, you have got
to use the attrib switch (/ah).

at c:\>, type the following:

dir *.xlt /s /ah