Excel does not Autofill with correct formula calculations

It seems like you are encountering an issue with Excel not updating the formula calculations correctly when using the autofill feature. This can happen if Excel is not recognizing the relative references properly. Here are a few things you can check or try:

1. Ensure Relative References: Make sure that your formula uses relative references correctly. For example, the formula =SUM(B4:E4) should change to =SUM(B5:E5) when dragged down to the next row. If it’s not, check if the references are locked (e.g., using $ signs).
2. Check Calculation Options: Ensure that Excel is set to automatically recalculate formulas. You can check this by going to the Formulas tab, then selecting Calculation Options and ensuring that Automatic is selected.
3. Re-enter the Formula: Sometimes, simply re-entering the formula in the first cell and then dragging it down can resolve the issue.
4. Clear Cache: If the issue persists, try closing and reopening Excel or clearing the cache, as it might be a temporary glitch.
5. Excel Version: Ensure that you are using a version of Excel that supports the features you are trying to use. Older versions may have limitations.

If these steps do not resolve the issue, consider checking for updates for Excel or repairing the Office installation.

Hi @Sonya Tercero,

Thank you for posting your question in the Microsoft Q&A forum.

Based on your description, the issue is highly because that your excel worksheet calculation options is set as Manual, not Automatic. You can try going to Formulas tab > Calculation Options > set to Automatic and try again to see if the issue persists. Also ensure that your formula doesn't contain any absolute reference symbol ($) so it won't lock your data range.

I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.    

Thank you for your patience and your understanding. If you have any questions or need further assistance, please feel free to share them in the comments so I can continue to support you. 

I look forward to hearing from you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.