| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: Can I open related files at one go ?
Hello,
I have an active file C which is extracting data from file A and B. File D, E and F in turn obtain data from file C. In Excel 2002, I understandf that the user is not able to open all the related files automatically when he open file C. What about in Excel 2007 ? Is there an option to open the related file at one go or selectively ? Can the user view the related file addresses at a dialog box ? This is important as the user might need to work on or view the other related files at the same time. Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007: Can I open related files at one go ?
Give this a try,
With all files open, make file C your main focus. Goto View tab, select Save Workspace. That should accomplish your task. It will not show teh location of the files, but they will each be listed in teh status bar and can be entered from there. HTH "Mr. Low" wrote: Hello, I have an active file C which is extracting data from file A and B. File D, E and F in turn obtain data from file C. In Excel 2002, I understandf that the user is not able to open all the related files automatically when he open file C. What about in Excel 2007 ? Is there an option to open the related file at one go or selectively ? Can the user view the related file addresses at a dialog box ? This is important as the user might need to work on or view the other related files at the same time. Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007: Can I open related files at one go ?
Yes, I got it.
Thanks for the tips. Low -- A36B58K641 "JR Hester" wrote: Give this a try, With all files open, make file C your main focus. Goto View tab, select Save Workspace. That should accomplish your task. It will not show teh location of the files, but they will each be listed in teh status bar and can be entered from there. HTH "Mr. Low" wrote: Hello, I have an active file C which is extracting data from file A and B. File D, E and F in turn obtain data from file C. In Excel 2002, I understandf that the user is not able to open all the related files automatically when he open file C. What about in Excel 2007 ? Is there an option to open the related file at one go or selectively ? Can the user view the related file addresses at a dialog box ? This is important as the user might need to work on or view the other related files at the same time. Thanks Low -- A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 is slow when more than 3 files are open | Excel Discussion (Misc queries) | |||
| I have Excel 2007. Some of my files open and some do not. Why? | Excel Discussion (Misc queries) | |||
| Excel 2007 - Can't open xls files from Explorer | Excel Discussion (Misc queries) | |||
| Excel 2007: Files do not open | Excel Discussion (Misc queries) | |||
| when i open a excel doc , it open muiltple page not related? | Excel Discussion (Misc queries) | |||
Linear Mode
