bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Files > Can't Open Multiple Workbooks from the Desktop

Can't Open Multiple Workbooks from the Desktop

Summary: Do you want to open multiple workbooks, all at the same time, from your Windows desktop? The trick is in what you do with the workbooks once they are selected. This tip explains that the secret is in how you click. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Agatha is running into a problem with some new systems in her office. Using the previous systems, Agatha could use the Windows Explorer to display a folder, select a group of workbooks in the folder, and then double-click one of them. When she did so, all the selected workbooks would open in Excel. When Agatha tries this on the new systems, the only workbook that opens is the one on which she double-clicks--her entire selection set of workbooks is ignored.

This behavior does, indeed, seem to be a change in Windows itself. What is happening is that when you double-click, Windows is canceling your selection set before it starts Excel. The first click of your double-click is effectively interpreted by Windows as a command to select only that one workbook.

The solution is to change how you are starting Excel. Instead of double-clicking on one of the workbooks in the selection set, right-click on one of the files and choose Open. The selection set remains intact and all the files are opened in Excel, as desired.

Tip #2427 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Got the Time? If you work with either times or dates in Excel, you really need ExcelTips: Times and Dates. Everything you need to know about slicing, dicing, and generally working with times and dates.

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)