Changing References to Formulas
 

Greetings,

I have a user who has copied an Excel Workbook (office 2003) and would like
to change the reference to differnt worksheets in her formula. Is there a
way to update the formulas in the worksheet without having to go to every
cell and make the change?

Any assistance would be greatly appreciated.

Changing References to Formulas
 

Go to Edit - Links.
Select one of the links, and then click "Change source"
Repeat as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tracia B" wrote:

Greetings,

I have a user who has copied an Excel Workbook (office 2003) and would like
to change the reference to differnt worksheets in her formula. Is there a
way to update the formulas in the worksheet without having to go to every
cell and make the change?

Any assistance would be greatly appreciated.