Hi
Forgive me if this has been asked before but none of the suggestions on the net seem to work for me.
I need to be able to copy a number of multiple array formulas in one workbook and paste them into another (different) workbook but without excel adding or changing any references contained in the arrays. A simple 'Copy & Paste'. I also need the copied arrays to be activated when they are pasted/copied into the other workbook.
I have 270 fairly complex array formulas on a worksheet within a workbook, too many to re-edit and the reactivate one by one.
The arrays normally work perfectly and do exactly what I need so I am keen to keep them.
For no apparent reason every so often I will open the worksheet to find the arrays are corrupt and no longer work or, on occasion, have just disappeared. This only happens to the array formulas and all other formulas within the workbook are unaffected.
I keep a backup copy of the workbook and from that I could copy the array formulas back into the main workbook but when I do excel adds references within the arrays back to the backup worksheet which is not what I need.
No matter what I try excel adds references back to the worksheet from which the arrays are copied.
Can anyone kindly help?
Forgive me if this has been asked before but none of the suggestions on the net seem to work for me.
I need to be able to copy a number of multiple array formulas in one workbook and paste them into another (different) workbook but without excel adding or changing any references contained in the arrays. A simple 'Copy & Paste'. I also need the copied arrays to be activated when they are pasted/copied into the other workbook.
I have 270 fairly complex array formulas on a worksheet within a workbook, too many to re-edit and the reactivate one by one.
The arrays normally work perfectly and do exactly what I need so I am keen to keep them.
For no apparent reason every so often I will open the worksheet to find the arrays are corrupt and no longer work or, on occasion, have just disappeared. This only happens to the array formulas and all other formulas within the workbook are unaffected.
I keep a backup copy of the workbook and from that I could copy the array formulas back into the main workbook but when I do excel adds references within the arrays back to the backup worksheet which is not what I need.
No matter what I try excel adds references back to the worksheet from which the arrays are copied.
Can anyone kindly help?
