It really shows the extension, right?
If yes, then that book1.xlsx is a real existing workbook--it's not a template.
So how are you starting this new document? Are you just opening excel and it's
in front of you?
If yes, then you could have a file (or multiple files) in your XLStart folder.
(That =cell() formula will help you locate that folder so you can clean up the
excel workbooks that don't belong there.) Move them to somewhere safe if you
want them--or delete them if you don't need them.
Or you could have a setting that says to open all files in a folder each time
excel starts.
In xl2007, this setting can be found:
Office Button|Excel Options|Advanced Section|General
Make sure that the "At startup, open all files in:" textbox is empty.
(I've never seen anyone use this effectively for more than a couple of days--and
they only worked on a single project for those days.)
You may have wanted to create a template workbook (book.xltm or book.xltx
(macros or no macros)) and saved them as normal workbooks in your XLStart folder
in error.
But I am confused about the names you say are created. If those names really
don't have extensions, then you should see that saveAs dialog.
If the names include the extensions, then it makes sense that you're saving
existing files and wouldn't see them.
========
And just to muddy the waters...
You could have a file named:
book.xlsx.xltx
that's really a template file.
But you've turned of showing extensions--that middle .xlsx isn't the extension.
It's just part of the filename. But you'd have to have done something bad in a
previous life for all that to actually happen.
========
I know you wrote about what you saw in the title bar, but that can be
misleading.
That =cell() formula won't lie. And it'll return an error if the file hasn't
been saved.
Charles said:
If I start a new document, the title bar shows a filename, like Book1.xlsx.
If I have a document open and click New Document, I'll get a new document
with something like Book2. If I keep clicking the new document icon to create
multiple documents the title bar on each will be book3 or book4 or book5. If
I click save on any of them, a file named book(x).xlsx is created where (x)
is the number after the word book.
Using the above example, I kept clicking the new document icon until I saw
book5 in the title bar. I clicked Save and the title changed to book5.xlsx.
When I entered the formula you provided in a cell in this book5.xlsx
document, it showed c:\documents and settings\callen\my
documents\[Book5.xlsx]Sheet1.
--
Charles Allen, MVP
:
What happens if you click Save now?
Does excel save the file?
If you type:
=cell("filename",a1)
in an empty cell, you'll see the path and workbook name (if the file has been
saved at least once).
Maybe that'll give you a hint of what's happening???
I'm guessing that you're editing an existing file (maybe book.xlt?) instead of
starting with a brand new workbook.
Charles Allen wrote:
There's definitely another problem. The question is, "What?"
--
Charles Allen, MVP
:
In 2007 I tried saving a new workbook and the save as dialogue opens up.
There should be some other problem..
If this post helps click Yes
---------------
Jacob Skaria
:
When creating a new document in 2007, I'd like to click Save and have the
system prompt me for a file name. In 2003, if you create a new document and
click the save button you are prompted for a file name. Is there a way to
have 2007 act like 2003?