Changing Source Data in a Formula

  • Thread starter Thread starter akimballsmith
  • Start date Start date
A

akimballsmith

I have two templates for the costs of our business. They both contain a
sheet called Material Costs and these two sheet need to be identical. I
don't want to input the same data twice so I made one of the sheets equal the
contents of the other sheet (they are in different files). The sheet updates
itself perfectly as a template. When I did a "save as" and renamed the files
I tried doing a replace to update the sheet that is the copy with the new
file name and I can't get it to work. Any help would be greatly appreciated.
 
Use the Edit Links menu and Change the source. That will allow you to point
to the renamed file and Excel should do the rest
 
Thank you very much, it worked great.

Duke Carey said:
Use the Edit Links menu and Change the source. That will allow you to point
to the renamed file and Excel should do the rest
Click to expand...
 

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

Complex formula help , please. 13
Can a cell pull info from another cell that is on a separate workb 3
My Cost Changed? Need Help to find the changes Compare values form 1
Update Source data in a formula 2
Need to merge worksheets - Excel 2003 0
Cannot copy worksheet to another file 2
Input sheet with INDEX formula 4
combining data multiple worksheets into one? 5

Back
Top