Did you try to copy...paste special...paste values?

"SelimTheDream" wrote:

Hello. I am trying to copy a worksheet that was linked to another file which
is on a server with limited access. I need to copy this single worksheet,
not entire workbook, to another users computer who doesn't have access to the
source files. When I open the document I get a lot of !REF response which is
expected cause it cannot read. Is there a way to copy the non-updated values
to another worksheet? Thanks in advance.