new workbook contains macros that reference original workbook, how do I switch this?

[deucekhk]

I created a new workbook from an existing one that adds an extra 2 sheets which both reference some of the original sheets. all of the original macros are still used for the same operation and I've added a new module with a few new macros for my two new sheets. upon opening this workbook it tells me that it there is a problem updating the links. how do I get the original macros, formulas, etc to reference the exact same things but on this new workbook? I've tried changing the source to the new workbook but it doesnt seem to like that.