| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 23893 | 2002-08-28 21:51:00 | Excel, 'Save' a new file, automatically saved as 'Book 1' | oggy (1250) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 74647 | 2002-08-28 21:51:00 | When I go to 'Save' (using CTRL & S) a new workbook for the first time it is automatically saved as 'Book 1' with no option for me to name it. I can get around it by going into the File menu and selecting 'Save As' but it is an inconvenience. | oggy (1250) | ||
| 74648 | 2002-08-28 21:55:00 | Sounds to me that excel is starting with an existing file called book1. Two questions: 1. when you do save something in book1, then quit excel, does the saved material appear when you start excel next time? 2. If you click NEW and have book2, and save that, does it ask you for a file name? It sounds like either a macro virus in your default template (I don't remember that being possible in Excel, but I think it might be) or you are starting excel with a file called book1. robo. |
robo (205) | ||
| 74649 | 2002-08-28 22:04:00 | Completely normal. Unless you "save as" the first time with a name and to a folder of choice. Word does the same. Bye |
Peter H (220) | ||
| 74650 | 2002-08-28 22:07:00 | No, it's not, click save the first time and it should run the "Save As" routine. robo. |
robo (205) | ||
| 74651 | 2002-08-28 22:10:00 | I am with Robo, its not normal. Every first save gives the "save as" both in word and in excel, in versions 95,97,2000 and XP. Nor can I find a setting to override it. |
godfather (25) | ||
| 74652 | 2002-08-28 22:16:00 | Clicking on save, brings up where to save & the name - in blue - as Book1.xls. Rename this to what you want. Bye |
Peter H (220) | ||
| 74653 | 2002-08-29 00:17:00 | This is a strange one. Check to see if there is a workbook or a shortcut in the XlStart or startup folder. These folders set defaults for when you open a new workbook, such as loading any addins or setting a default workbook (much like normal.dot). You will find the folder in the folder where you installed office, typically "C:\Program Files\Microsoft Office\Office\XlStart or startup". By default you shouldnt have any shortcuts or Xl files in this folder other than perhaps a file called mscreate which can stay in the XLStartup/Startup. If there is nothing in there then when you open a new workbook, select Tools-Macros-Macros and advise if there are any macros there, especailly one called Auto_Open. Normally you wont have any macros on a new document. Im thinking you have a corrupt book.xlt template but I dont know where this is. With word you can delete the normal.dot and it will rebuild a new one. Im presuming Excel will do the same if you can find the default template. There is a great website called mr excel hich has a message board you can put your question to. The boards full of very experienced users of Excel and would be able to help better than me. Go to http://www.mrexcel.com/ and select the message board then signup and post your question. regards Parry |
parry (27) | ||
| 74654 | 2002-08-29 00:59:00 | Hi Peter, thats his problem. When he selects Save its not bringing up the SaveAs dialog box (which is the default dialog if the workbook ha not already been saved) but just saving the workbook. He hasnt hd the chance to save the file as a nme he wants. | parry (27) | ||
| 74655 | 2002-08-29 01:07:00 | Exactly Parry! Your message timed 11.59 describes it better than I originally did. I'll try what you suggested in your earlier response and see how I get on. Cheers | oggy (1250) | ||
| 74656 | 2002-08-29 01:20:00 | Robo. Re your reply of 8.55, YES and YES. Oggy |
oggy (1250) | ||
| 1 2 | |||||