For this very basic string:

='\\WAREHOUSEPC\Ostendo\[ItemMasterImport.XLS]ItemMasterImport'!$H$2

I used to be able to paste the same into the next cell down then highlight the top two columns and drag down so that the formula increased by one for each row. Now it just repeats the same two over & over which makes no sense as the the reasoning by me. how do i change the settings so the formula will increase by one with each row?