Hi,
I have 2 spread sheets Linked together for accounting purposes, one spreadsheet is a template for invoicing which the linking part works great, i needto be able to save the spread sheet and cancel the connection so results dont change if the the other spreadsheet has been modified.
i have tried some vba and changed the edit links but can not for life of me get it to work as i want it to.
any help would be appreciated, cheers.
I have 2 spread sheets Linked together for accounting purposes, one spreadsheet is a template for invoicing which the linking part works great, i needto be able to save the spread sheet and cancel the connection so results dont change if the the other spreadsheet has been modified.
i have tried some vba and changed the edit links but can not for life of me get it to work as i want it to.
any help would be appreciated, cheers.