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

deucekhk

New Member
Joined
Mar 7, 2014
Messages
4
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.
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,119,024
Messages
5,575,646
Members
412,682
Latest member
salmanahmad84
Top