How to automatically open files when started Excel?
Sometimes, some workbooks are used usually, such as schedule workbooks which needed to be open every day. In this case, you may want to auto open such these workbooks while Excel starting replace to find them and open one by one. Here, in this tutorial, it provides two methods on handling the auto-open files when started Excel.
Automatically open specific workbooks in read-only state when Excel started
Automatically open specific workbooks and support editor when Excel started
Automatically open workbooks in a folder when Excel started
If you want to read some specific workbooks every day, you can do as below steps to set automatically open the workbooks while Excel started.
1. Enable Excel, click File > Options to display the Excel Options dialog, the click Trust Center > Trust Center Settings.
2. In the Trust Center dialog, click Trusted Locations, and double click at C:\...Office\Office16\XLSTART\.
3. In the popping Microsoft Office Trusted Locations dialog, in the Path section, select the while path C:\Program Files\Microsoft Office\Office16\XLSTART\ and press Ctrl + C to copy this path.
4. Open a folder, and then press Ctrl + V to paste this copied path to replace its original path, then press Enter key to go to the folder of this path.
5. Then copy and paste the workbooks into the folder XLSTART.
From now on, these workbooks you place at folder XLSTART will be automatically opened while Excel started.
Note:
These workbooks which are automatically opened cannot be overwrite, it will pop a dialog as below when you try to save them.
If you want to edit the workbooks which are auto opened while Excel started, you can try this function – Auto Open Those Workbooks Next Time in Kutools for Excel.
| Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. | ||
After free installing Kutools for Excel, please do as below:
1. Open all workbooks you want them to be automatically opened while Excel enable.
2. Click Kutools Plus > Workbook > Auto Open Those Workbooks Next Time.
3. In the popping dialog, check all workbooks that you want them be opened while Excel started. Click Ok.
Now, while you enable Excel, all the checked workbooks in the Auto Open Those Workbooks Next Time dialog will be opened.
If you want to automatically open workbooks in a folder and be allowed to overwrite them, you can do as below:
1. Click File > Options.
2. Then in the Excel Options dialog, click Advanced tab in left pane, and in right part of the dialog, under General section, paste the folder path which you want to open in ever time Excel started into the At startup, open all files in textbox.
3. Click OK. From now on, while you start Excel, all workbooks in the specific folder will be opened.
Note:
Only files in Excel format can be opened, other types of files will not be opened.
These workbooks can be saved if there are some changes.
The files in subfolder cannot be opened.
Quickly search a value in multiple sheets or workbooks
Have you ever imaged to search a certain value in multiple sheets or workbooks in Excel? This tutorial introduces some different methods to solve the problems about searching in multiple sheets or searching in multiple workbooks.
Export and save each worksheet as separate new workbook in Excel
Let's say you want to export and save one or several worksheets as a new workbook, how will you deal with it? Normally you may copy each worksheet and paste to new workbook. But here we bring you some handy tricks to deal with it:
Insert worksheets from another workbook
Sometimes you may need to import worksheets from other workbooks. If you copy the worksheets' content and paste to current workbook, it loses some formatting styles, such as row height, etc. This article describes some handy ways to insert worksheets from other workbooks quickly with losing data and formatting styles.
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns and Keeping Data; Split Cells Content; Combine Duplicate Rows and Sum/Average... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Favorite and Quickly Insert Formulas, Ranges, Charts and Pictures; Encrypt Cells with password; Create Mailing List and send emails...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- Pivot Table Grouping by week number, day of week and more... Show Unlocked, Locked Cells by different colors; Highlight Cells That Have Formula/Name...
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
