Search results
Results from the WOW.Com Content Network
Go to C:\Users\User_Name\AppData\Roaming\Microsoft\Excel as in Option 1 (This path is one level lower of XLSTART) and change the extension of .xlb file (s) to something else say .xlb1. Close Excel and restart Excel again. Your old .xlb file will be there in the folder so that in case you need it in future.
Replied on March 24, 2017. Report abuse. You need to save your Book1.xlsx as Book.xltx (File > Save As > Type would be Excel Template *.xltx) into XLSTART folder. Delete Book1.xlsx from XLSTART (or move to somewhere else but don't keep in XLSTART) Sincerely yours, Vijay A. Verma @ https://excelbianalytics.com. Thanks for your feedback, it helps ...
Please check below folders: C:\Program Files\Microsoft Office\Office12\XLSTART. C:\Documents and Settings\ (*** User Name****)\Application Data\Microsoft\Excel\XLSTART. Delete Book1 file from both location,if exists... This will resolve your issue. Thanks for your feedback, it helps us improve the site. Replies (5) .
If yes, use windows start button to search for your xlstart folder. If there's a file named book1.xls in there, move it or delete it. Don't delete any file named book.xlt or sheet.xlt. If that doesn't work, use windows start button|search to look for book1.xls. When you find it, move it or delete it.
Re: Stop Opening Book1! Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel. Worksheet. Then if running Win98 OS Edit> select "Open" and Edit. If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit. In Command line the path should be similar to this....
Excel Programming / VBA / Macros. [SOLVED] Excel 2K3: Opening spreadsheet, also opens book1.xls? The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed.
If you want to change the blank new workbook that is opened when you start Excel or press Ctrl+N, modify the blank workbook to suit your needs, then save it as a Microsoft Excel template named Book.xltx (this name is obligatory) in your Excel startup folder. By default, that is. C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART.
If you mean that it starts up with Book2 rather than Book1 that could be because you have another instance of Excel still open (even invisibly) or you earlier had one that crashed. Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk. Thanks for the reply. Yes, it starts with Book 1 & Book 2.
Set myBook1 = GetObject("Book1.xls") If the software just create a workbook without saving then the name should Book1 without the file extension. So double check if the file is automaticly saved as this may cause the code to fail. My code assume your software only returns one chart and the underlying data at a time.
If that workbook is really named book1.xls, look in your XLStart folder for Book1.xls. And check tools|options|General tab There's a box that allows you to specify a folder: "At startup, open all files in:" Either delete the entry from that box or remove book1.xls from that folder. ps.