If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excedl 2003 / How to automize file opening
Hello Everyone
below, my issue with excel 2003: When opening my "mainfile.xls", I wish it could open others "datafileS.xls", needed for my calculation within "mainfile.xls". All files are located in the same directory. a. mainfile.xls b. datafile1.xls c. datafile2.xls d. datafile3.xls In "mainfile.xls", I do use function such as INDIRECT("Datafile1.xls.....), to calculate various figures using my data files. My main problem is that if all my "datafileS.xls" are not opened when launching "mainfile.xls", this one cannot retrieve the data, and shows all cells with: #REF" Your help would be really appreciated, by the way, happy week-end to all members. Ced |
#2
|
|||
|
|||
Excedl 2003 / How to automize file opening
Hi Ced,
When opening my "mainfile.xls", I wish it could open others "datafileS.xls", needed for my calculation within "mainfile.xls". All files are located in the same directory. You can solve this in a number of ways, the easiest being creating a workspace file. Open all files that belong together and then choose file, save workspace. This saves what files you have open at a specific moment. Opening a workspace file then causes all pertaining workbooks to be opened automatically. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
#3
|
|||
|
|||
Excedl 2003 / How to automize file opening
Jan,
prompt answer, thank you very much, have a nice week-end. Cedric "Jan Karel Pieterse" wrote: Hi Ced, When opening my "mainfile.xls", I wish it could open others "datafileS.xls", needed for my calculation within "mainfile.xls". All files are located in the same directory. You can solve this in a number of ways, the easiest being creating a workspace file. Open all files that belong together and then choose file, save workspace. This saves what files you have open at a specific moment. Opening a workspace file then causes all pertaining workbooks to be opened automatically. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
#4
|
|||
|
|||
Excedl 2003 / How to automize file opening
Hi Ced,
have a nice week-end. Same to you! Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Opening MDE file in Access 2003 created in Access 97 | John Shearan | General Discussion | 1 | August 28th, 2005 08:55 PM |
Opening and Saving file in Office 2003 | Elton Seng Yan Thung | General Discussions | 2 | December 22nd, 2004 01:48 PM |
Unsafe Attachments | Ron | Installation & Setup | 2 | June 9th, 2004 01:55 AM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |