How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

i am using excel 2010 and have a file linked to another. unfortunately

Customer Question

i am using excel 2010 and have a file linked to another. unfortunately the links do not stay linked. if i relink the file works, but when i open up the links are not working again.
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  John D replied 4 years ago.



It depends on which method you are using to link to the file. If you are using formulas the best way to fix the links is to open both files, the relink to the formulas to the source by typing an equal sign in the destination cell ad then navigating with your mouse to the source cell in the other file and hitting enter. Then save the file


Hope this helps


Customer: replied 4 years ago.



i do understand how to fix the link when it is broken. What i want to know is how to make it so the link does not get broken. it appears that excel now looks to my local computer for the path instead of going to the network.

Expert:  John D replied 4 years ago.

Please send me the file so I can take a look


Customer: replied 4 years ago.

do you have a number that i can reach you at? my # is XXX-XXX-XXXX


Expert:  John D replied 4 years ago.
Bill this site does not permit making phone calls