On Jul 31, 9:58*am, houghi wrote:

I have something that refers to another cell in another file:
='[Weekly.xls]17'!$D$7

This works great.

Forgive me to go a little bit off topic - but can you arrange a
formula, which transfer not only the plain content of given cell but
also all the assisting formating, e.g. hyperlinks?

I have one worksheet with an hyperlinked cell but when I try to use
your formula in another worksheet towards that cell, it displays only
the name of that cell, leaving the hyperlink behind. Is there any cure
for it?

Thank you for your response

regarding "all the assisting formating" functions CANNOT do that

as regs hyperlinks I wasnot able to find a solution