Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing Default Paste behavior | Excel Discussion (Misc queries) | |||
Setting Up Default Behavior | Excel Discussion (Misc queries) | |||
Weird worksheet saving behavior | Excel Discussion (Misc queries) | |||
How do I change the default Paste behavior | Excel Discussion (Misc queries) | |||
Text Only Default Behavior? | Excel Discussion (Misc queries) |