I have a source file and a destination file. I have simply linked destination to source by using =[source File]!cell address.
Changed the absolute to relative and dragged to nos of cells reqd. so far so good. But once I insert a row or column in source file the destination file doesn't update to new cell address but displays the old one. what is the solution ? No VBA Please.
Changed the absolute to relative and dragged to nos of cells reqd. so far so good. But once I insert a row or column in source file the destination file doesn't update to new cell address but displays the old one. what is the solution ? No VBA Please.