![]() In the Edit Links dialog, select all workbooks listed. =INDEX(‘C:\Reports\ActGL.xls’!DataMonth,$B11,E$10)Ĭhoose Edit, Links. When you have this problem, you’ll usually see a path name within the INDEX function, something like this: One reason could be that the reference is to a workbook that isn’t open. There are several likely reasons for this. If Excel gives you an error when you try to go to INDEX(whatever), you know that your INDEX isn’t returning a good reference.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |