Microsoft Office Questions? Ask a IT Expert for Support ASAP
Yes that's correct. Imagine I have put =sum(A1+B1) and click/dragged the formula down 10 rows. The top cell calculates the correct value but I have to manually click on each cell below, press enter for the formula amend to the correct end value. I didn't have this issue with my older version as of course it automatically amends the value in the cell once the formula is copied.
Your a legend! Let me know if you need any advice on wine.