How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Ryan-CTech Your Own Question
Ryan-CTech, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 541
Experience:  Expert VBA Programmer.
Type Your Microsoft Office Question Here...
Ryan-CTech is online now
A new question is answered every 9 seconds

Excel 2010. does not auto calculate formulas. Settings are

Customer Question

Excel 2010. does not auto calculate formulas. Settings are set to "Auto calculate". I have to manually initiate calculation (F9). As from the moment I change or add 1 formula in the workbook, all calculations jump to N/A. The formula concerned:

This multiplies a number by another number I go and retrieve by looking up the name of the sheet in a range on another sheet :)

Any ideas?
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Rachel-Mod replied 4 years ago.
I'm a moderator for this topic. I've been working hard to find a professionals to assist you with your question , but sometimes finding the right professionals can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!
Customer: replied 4 years ago.


seen the importance (for me), it is ok to wait till you find an expert.



Expert:  Rachel-Mod replied 4 years ago.


Thank you, we will continue to look for a professional to assist you. Please let me know if I can be of any further assistance while you wait.



Expert:  Ryan-CTech replied 4 years ago.
Welcome To Just Answer!

Give this a try for me please.

Open your Workbook and press Alt + F11 to open the VBA Editor.

In the list on the Left Double Click "ThisWorkbook".

A blank white page will open in the middle.

Paste in this code.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
End Sub

Close the VBA Editor and Save the changes.

Then try it out :)