Yeah....that linking is a roadblock! There might be a way to overcome that, but it might be considered amaturish! But, if you like the idea of having the ability to operate the Excel sheet right there in BV; you can put a rectangle shape, transparent, over each of the linked cells and link it to the corresponding url. I tried it and it worked, at least in preview mode.

Otherwise, all I can think of is to recreate the entire sheet into a BV table!