Forum Discussion
Solved
Formula Copy/Paste Help
I think my question is fairly basic, but I don't have the savviest understanding of Excel and I'm completely mystified about where I'm going wrong. I'm using VLOOKUP and named cells to create a solv...
- Activate the Formulas tab of the ribbon. Make sure that Calculation Options is set to Automatic.
- Check the status bar at the bottom of the workbook window. Do you see Circular References near the left-hand side? If so, try to find the cell(s) containing a circular reference and change or delete the formula in that cell/those cells.
- Activate the Formulas tab of the ribbon. Make sure that Calculation Options is set to Automatic.
- Check the status bar at the bottom of the workbook window. Do you see Circular References near the left-hand side? If so, try to find the cell(s) containing a circular reference and change or delete the formula in that cell/those cells.
- Thank you so much you saved the day. It looks like the Calculation Options was set to Manuel which was causing my error.
