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?
--
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


"Charles Allen" wrote:

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?
--
Charles Allen, MVP

There's definitely another problem. The question is, "What?"
--
Charles Allen, MVP



"Jacob Skaria" wrote:

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


"Charles Allen" wrote:

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?
--
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

"Jacob Skaria" wrote:

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


"Charles Allen" wrote:

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?
--
Charles Allen, MVP


--

Dave Peterson

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



"Dave Peterson" wrote:

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

"Jacob Skaria" wrote:

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


"Charles Allen" wrote:

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?
--
Charles Allen, MVP


--

Dave Peterson

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 Allen wrote:

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

"Dave Peterson" wrote:

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

"Jacob Skaria" wrote:

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


"Charles Allen" wrote:

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?
--
Charles Allen, MVP


--

Dave Peterson


--

Dave Peterson

No, the extension doesn't appear at first. I just started Excel with a new
document. It shows Book1 - Microsoft Excel. If I click New Document three
more times I get Book 2- Microsoft Excel, etc.

So how are you starting this new document? Are you just opening excel and
it's in front of you? Yes. For successive new documents I'm pressing
<Ctrl-N.

The field "At startup, open all files in" is empty.

The XLSTART folder is empty.


--
Charles Allen, MVP



"Dave Peterson" wrote:

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 Allen wrote:

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

"Dave Peterson" wrote:

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

"Jacob Skaria" wrote:

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


"Charles Allen" wrote:

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?
--
Charles Allen, MVP


--

Dave Peterson


--

Dave Peterson

And what does the =cell() formula show in those new workbooks?

If it returns an error, then I don't have a guess why the SaveAs dialog doesn't
appear for you.

But I do have another followup...

If you open excel in safe mode:
Windows start button|Run
Excel /safe

And then hit ctrl-n (and try the =cell() stuff), what happens when you save?

I'm hoping (but without any confidence) that it works fine. That would mean
that you may have a "helpful" macro/addin that's stealing the Save icon's
function.



Charles Allen wrote:

No, the extension doesn't appear at first. I just started Excel with a new
document. It shows Book1 - Microsoft Excel. If I click New Document three
more times I get Book 2- Microsoft Excel, etc.

So how are you starting this new document? Are you just opening excel and
it's in front of you? Yes. For successive new documents I'm pressing
<Ctrl-N.

The field "At startup, open all files in" is empty.

The XLSTART folder is empty.

--
Charles Allen, MVP

"Dave Peterson" wrote:

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 Allen wrote:

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

"Dave Peterson" wrote:

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

"Jacob Skaria" wrote:

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


"Charles Allen" wrote:

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?
--
Charles Allen, MVP


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

I entered =cell("filename",a1) and nothing appears. The formula does appear
in the formula bar.

If I save the document, then it shows c:\documents and settings\callen\my
documents\[Book1.xlsx]Sheet1


--
Charles Allen, MVP



"Dave Peterson" wrote:

And what does the =cell() formula show in those new workbooks?

If it returns an error, then I don't have a guess why the SaveAs dialog doesn't
appear for you.

But I do have another followup...

If you open excel in safe mode:
Windows start button|Run
Excel /safe

And then hit ctrl-n (and try the =cell() stuff), what happens when you save?

I'm hoping (but without any confidence) that it works fine. That would mean
that you may have a "helpful" macro/addin that's stealing the Save icon's
function.



Charles Allen wrote:

No, the extension doesn't appear at first. I just started Excel with a new
document. It shows Book1 - Microsoft Excel. If I click New Document three
more times I get Book 2- Microsoft Excel, etc.

So how are you starting this new document? Are you just opening excel and
it's in front of you? Yes. For successive new documents I'm pressing
<Ctrl-N.

The field "At startup, open all files in" is empty.

The XLSTART folder is empty.

--
Charles Allen, MVP

"Dave Peterson" wrote:

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 Allen wrote:

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

"Dave Peterson" wrote:

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

"Jacob Skaria" wrote:

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


"Charles Allen" wrote:

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?
--
Charles Allen, MVP


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

And if you start in safe mode?

Charles Allen wrote:

I entered =cell("filename",a1) and nothing appears. The formula does appear
in the formula bar.

If I save the document, then it shows c:\documents and settings\callen\my
documents\[Book1.xlsx]Sheet1

--
Charles Allen, MVP

"Dave Peterson" wrote:

And what does the =cell() formula show in those new workbooks?

If it returns an error, then I don't have a guess why the SaveAs dialog doesn't
appear for you.

But I do have another followup...

If you open excel in safe mode:
Windows start button|Run
Excel /safe

And then hit ctrl-n (and try the =cell() stuff), what happens when you save?

I'm hoping (but without any confidence) that it works fine. That would mean
that you may have a "helpful" macro/addin that's stealing the Save icon's
function.



Charles Allen wrote:

No, the extension doesn't appear at first. I just started Excel with a new
document. It shows Book1 - Microsoft Excel. If I click New Document three
more times I get Book 2- Microsoft Excel, etc.

So how are you starting this new document? Are you just opening excel and
it's in front of you? Yes. For successive new documents I'm pressing
<Ctrl-N.

The field "At startup, open all files in" is empty.

The XLSTART folder is empty.

--
Charles Allen, MVP

"Dave Peterson" wrote:

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 Allen wrote:

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

"Dave Peterson" wrote:

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

"Jacob Skaria" wrote:

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


"Charles Allen" wrote:

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?
--
Charles Allen, MVP


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

As it happens, there is a com add-in that is causing the behavior.
Unfortunately, the add-in is important for other purposes. But at least I
know what the explanation is. Thank you for your help.
--
Charles Allen, MVP



"Dave Peterson" wrote:

And if you start in safe mode?

Charles Allen wrote:

I entered =cell("filename",a1) and nothing appears. The formula does appear
in the formula bar.

If I save the document, then it shows c:\documents and settings\callen\my
documents\[Book1.xlsx]Sheet1

--
Charles Allen, MVP

"Dave Peterson" wrote:

And what does the =cell() formula show in those new workbooks?

If it returns an error, then I don't have a guess why the SaveAs dialog doesn't
appear for you.

But I do have another followup...

If you open excel in safe mode:
Windows start button|Run
Excel /safe

And then hit ctrl-n (and try the =cell() stuff), what happens when you save?

I'm hoping (but without any confidence) that it works fine. That would mean
that you may have a "helpful" macro/addin that's stealing the Save icon's
function.



Charles Allen wrote:

No, the extension doesn't appear at first. I just started Excel with a new
document. It shows Book1 - Microsoft Excel. If I click New Document three
more times I get Book 2- Microsoft Excel, etc.

So how are you starting this new document? Are you just opening excel and
it's in front of you? Yes. For successive new documents I'm pressing
<Ctrl-N.

The field "At startup, open all files in" is empty.

The XLSTART folder is empty.

--
Charles Allen, MVP

"Dave Peterson" wrote:

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 Allen wrote:

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

"Dave Peterson" wrote:

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

"Jacob Skaria" wrote:

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


"Charles Allen" wrote:

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?
--
Charles Allen, MVP


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson