#REF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to send to my friend a file with links cells to another files in my
computer. But when my friend open the file, Excel ask about to update the
links and he answer no update, but when the file open the cells when this
links show #REF message. How can i do to send my file with the information in
the linked cells without excel show me the #REF message?

Thanks
 
Copy all formulas, then paste them unto a new workbook and paste special as
values, then send that workbook

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook linkage returns #REF! 4
Oop's I did it again! 5
link two spreadsheets and copy cell ref accross row 2
Open and Close a Workbook to Update Links 3
Cancel automatic updates of linked values 3
Wits end wrt automatic linking 3
External Link Problem 8
Using a #Ref! in a column Sum 3

Back
Top