Opening multiple Excel files within the same Excel window.

lost9471 · #1 07-24-2007, 07:47 AM

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.

Kristiina · #2 05-01-2010, 11:16 AM

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

zyzzyva57 · #3 05-01-2010, 01:57 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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