Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: HYPERLINK function returns "Cannot open specified file" Hi, This did solve my problem with the error messages I was getting but its not dynamic and moving when rows are added in. Please, can you help? =HYPERLINK("#Sheet1!A20", "Fuel Systems") Damien_Rosario