Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking between workbooks and getting #REF error
I am trying to link several excel files into a consolidated excel file. I
already linked 3 files to the consolidated, but when I attempt to link the 4th, I am getting a #REF error. Here is what I am doing: I am highlighting the array I want to link from the individual file to the consolidated file. I copy that section. I go to the consolidated file, and paste special. I choose Paste Link: Microsoft Excel 8.0 Format. The consolidated file shows the #REF after doing so. I did the same process for the previous three files, and everything worked fine. Can anyone help? Thanks, TM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|