Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-24-2007, 07:47 AM
lost9471 lost9471 is offline
Novice
Opening multiple Excel files within the same Excel window.
 
Join Date: Jul 2007
Posts: 1
lost9471
Default Opening multiple Excel files within the same Excel window.

What I am trying to accomplish is to have excel open, then select another file, through windows explorer, and have it open within the already open excel window. Not open another excel window.



I have tried using the "/e" switch, and this does not work. I can also stack the icons on the toolbar, however this is not working either.

I am using Windows XP Pro, and Office 2003.
Reply With Quote
  #2  
Old 05-01-2010, 11:16 AM
Kristiina's Avatar
Kristiina Kristiina is offline Opening multiple Excel files within the same Excel window. Windows Vista Opening multiple Excel files within the same Excel window. Office 2007
Advanced Beginner
 
Join Date: Apr 2010
Posts: 58
Kristiina is on a distinguished road
Default

What you can do is clicking on the Excel Maximise button next to X on the top right corner. This makes the excel workbooks visible in one window.


Rgrds,
Kristiina
Reply With Quote
  #3  
Old 05-01-2010, 01:57 PM
zyzzyva57 zyzzyva57 is offline Opening multiple Excel files within the same Excel window. Windows 7 Opening multiple Excel files within the same Excel window. Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

Open the workbooks you want, then under the View tab, go to Arrange All and pick how you want to see both workbooks (do NOT click Window of active workbook)

Now you can easily Cut/Copy and Paste between the workbooks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening multiple Excel files within the same Excel window. Help problem with excel MMCSSK15 Excel 1 05-01-2010 11:19 AM
Trick to restrict opening excel/word ?? 9morebusy Excel 0 11-12-2008 04:18 AM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM
Delete excel files by code in Access Barry Richardson Office 0 06-13-2005 06:26 AM
How to do grouping in Excel volcane Excel 2 04-30-2005 09:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft