updating the formula when an excel file is moved.

  • Thread starter Thread starter NT1
  • Start date Start date
N

NT1

hi there,

Today, I encounter a problem while doing my little excel files cleanup. I
have 2 excel files. I will called them A and B. There are formulas in
files A which link to cells in files B. When I move files B to another
directory, the formulas in files A all screwed up as it cannot locate the
files B. Is there any way to redo the forumlas without change the forumlas 1
by 1 ?

Much appreciated.

NT
 

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

Excel Formula Missing Cells Due To Hardware 2
Formula shows in cell instead of results (text reference) 4
Formula showing in cell 4
Complicated Formula 5
Dragging a formula across the row in 2007 2
formula returns the formula 2
Countif Based on Date Range 3
HLOOKUP static cell reference 1

Back
Top