copy array formula

A

ACCA

New member
Joined
Feb 7, 2017
Messages
23
Reaction score
0
Points
1
Excel Version(s)
excel 2007
dear all ,

when i copy an array formula to range of cells then error message displayed "you cannot change part of an array formula" , it is possible to copy without dragging.
 
What you will need to do is delete the array formulae from all cells, then re-enter the amended version, then you can drag copy down.
 
You must log in or register to reply here.
Back
Top