I have recently upgraded to office 12 which seems to calculate things quite differently. I have managed to fix the "manual calculation thing to automattic" & can't understand why that is the default but have one I can't find the settings for.
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?
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?