Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Excel Files
If I link two files save and close both then just open 1 of those, it
doesnt pick up the links/formulas and shows #VALUE! for each cell, until the other one is open too. I manually linked them ie open 2 files; in one cell type = then go to the other file and link accordingly. On the same note sometimes I link the entire file or tab from the same file (ie ctrl+K then select the file or tab) but often that also fails to reopen. First I thought its because I am linking different Excel files ie Excel 97-2003 with xls (Excel 2007). Or xls with macro to xls without macro etc. But even I tried linking the same files eg xlsm with xlsm still the same problem. For future reference - do you reckon linking different excel files could have caused this problem? Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Excel Files
Excel may not know where is source data is:
1. start with no files open 2. open or create the file with the source data in it 3. leaving the source file still open, open or create the file with the links 4. save the source file 5. close the source file 6. examine the links in the link file. the paths should be correct 7. save and close the link file 8. if you re-open the link file the linked data should still be good. -- Gary''s Student - gsnu200802 "Salman" wrote: If I link two files save and close both then just open 1 of those, it doesnt pick up the links/formulas and shows #VALUE! for each cell, until the other one is open too. I manually linked them ie open 2 files; in one cell type = then go to the other file and link accordingly. On the same note sometimes I link the entire file or tab from the same file (ie ctrl+K then select the file or tab) but often that also fails to reopen. First I thought its because I am linking different Excel files ie Excel 97-2003 with xls (Excel 2007). Or xls with macro to xls without macro etc. But even I tried linking the same files eg xlsm with xlsm still the same problem. For future reference - do you reckon linking different excel files could have caused this problem? Thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Excel Files
Thanks Gary
If I open the source file, it corrects the formula in the other file but if I only open the linked file (while source file is not opened) it shows #VALUE!. Is there any way to get rid of this error without even opening the source file otherwise I will have to open and close alot of files before I start work on any Excel file as most of my files are linked to many other files. At present its taking alot of time to open all other files, save and then close those to get rid of #VALUE! errors. I was wondering if there is any other way to get rid of these errors. Thanks "Gary''s Student" wrote: Excel may not know where is source data is: 1. start with no files open 2. open or create the file with the source data in it 3. leaving the source file still open, open or create the file with the links 4. save the source file 5. close the source file 6. examine the links in the link file. the paths should be correct 7. save and close the link file 8. if you re-open the link file the linked data should still be good. -- Gary''s Student - gsnu200802 "Salman" wrote: If I link two files save and close both then just open 1 of those, it doesnt pick up the links/formulas and shows #VALUE! for each cell, until the other one is open too. I manually linked them ie open 2 files; in one cell type = then go to the other file and link accordingly. On the same note sometimes I link the entire file or tab from the same file (ie ctrl+K then select the file or tab) but often that also fails to reopen. First I thought its because I am linking different Excel files ie Excel 97-2003 with xls (Excel 2007). Or xls with macro to xls without macro etc. But even I tried linking the same files eg xlsm with xlsm still the same problem. For future reference - do you reckon linking different excel files could have caused this problem? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to text files in Excel | Excel Discussion (Misc queries) | |||
HELP linking to PDF files from Excel sheet on CD | Excel Discussion (Misc queries) | |||
Having some problems linking an array across excel files | Excel Discussion (Misc queries) | |||
Linking two excel files | Excel Discussion (Misc queries) | |||
linking picture files to excel | Excel Discussion (Misc queries) |