Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem after rename of file
"File1_2006.xls" is data input file (one year record)
"File2_2006.xls" is display file (extract info from above file) and contains 50sheets to display info by using =C:\[file1_2006.xls]details'!A1 =C:\[file1_2006.xls]details'!A2 =C:\[file1_2006.xls]details'!B5 ........ ........ =C:\[file1_2006.xls]details'!A10 For the year 2007, I delete all the info in "File1_2006.xls" and rename it as "File1_2007.xls". I also save "File2_2006.xls" under new file name "File2_2007.xls". However, all the formulas in "File2_2007.xls" still link to "File1_2006.xls" and is there a way where I can make all the formulas in "File2_2007.xls" to link to "File1_2006.xls". Or is there a better way to do it, 1 file for input and the other to display info extract from the first . Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem opening hyperlink to PDF file in Excel 2003 | New Users to Excel | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
Interesting TIF file problem | Excel Discussion (Misc queries) | |||
opening file problem please help | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |