Copying a linked worksheet

S

SelimTheDream

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.
 
S

Scoops

SelimTheDream said:
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.
Click to expand...

Hi SelimTheDream

Try Edit>Paste Special > Values > OK

Regards

Steve
 
G

Gord Dibben

Copy the worksheet by right-click on tab and "move or copy" to a new workbook.

Select all cells and copy then paste special>values.

Save as and send to user.


Gord Dibben MS Excel MVP
 
S

SelimTheDream

I tried everything but didn't work. Besides when I say paste special>values
it becomes all mixed up. Thanks for the info though.

"Gord Dibben":
 
Top