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 Jess M. Your Own Question

Jess M.
Jess M., Computer Support Specialist
Category: Computer
Satisfied Customers: 6395
Experience:  Computer Hardware & Software Specialist - 10yrs Exp, Web Designer & Developer
49766785
Type Your Computer Question Here...
Jess M. is online now

I have mac computer and use excel handlin. When I

Resolved Question:

I have mac computer and use excel for data handlin. When I up date a column of data (f) the adjacent column should automatically update also but doesn't, Individually they do but I have to click and enter each one
ie =f9*G9/100
Any ideas how to retore the automatic function?
Regards
Roy
Submitted: 1 year ago.
Category: Computer
Expert:  Jess M. replied 1 year ago.
Hi Roy, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.I am very sorry about your Excel issues. I believe the settings in your MS Excel was changed to NOT automatically calculate formulas. To restore this to automatically calculate formulas, please do the following:Open Excel and load the file that you are working on.Click on File menu then click on Options (Or Excel Options in other versions)In the Options dialog box, click on Formulas at the left panelThen in the corresponding settings shown in the right, in the Workbook Calculation group, select Automatic. Here is the link of my screen shot:http://filesxpress.com/d-32f7b4f8Click Apply buttonClick OK button.This shall fix your issues. I hope that helped. Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.Thank you!Best regards,Jess
Jess M., Computer Support Specialist
Category: Computer
Satisfied Customers: 6395
Experience: Computer Hardware & Software Specialist - 10yrs Exp, Web Designer & Developer
Jess M. and 6 other Computer Specialists are ready to help you
Customer: replied 1 year ago.

Thank you, ***** ***** at the answer but could not find the section referred to in my version of XL mac 2011 Ver. 14.5.7 (151005) The File menu/options does not appear to exist.


Regards

Roy
Expert:  Jess M. replied 1 year ago.
Hi Roy,Thank you for writing back. Since you are suing Excel for Mac, please do the following:On the Excel menu, click Preferences.Under Formulas and Lists, click Calculation .Under Calculate sheets, select Automatic (or Automatically), and then click OK.​I hope that helped.Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.Thank you!Best regards,Jess

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • Kamil Anwar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    156
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg Kamil Anwar's Avatar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    156
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    93
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/JO/JonTech/2011-10-25_111835_A2c.64x64.jpg Jon-Tech's Avatar

    Jon-Tech

    IS Manager

    Satisfied Customers:

    61
    20 yrs: Computers, Networking
  • http://ww2.justanswer.com/uploads/JA/jamieratliff/2012-2-8_194551_jamie.64x64.jpg jamieratliff's Avatar

    jamieratliff

    Information Systems Manager

    Satisfied Customers:

    21
    Jamie has worked in the Information Technology field for over a decade.
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERleg4q7o8/2012-3-6_203036_meja.64x64.png TheDoctor's Avatar

    TheDoctor

    Software Engineer

    Satisfied Customers:

    16
    Experienced Software Engineer
  • http://ww2.justanswer.com/uploads/FI/FisherEngineering/2012-1-18_194422_Fisher375Headshotcompressed239K.64x64.jpg Bill Fisher's Avatar

    Bill Fisher

    Computer Engineer

    Satisfied Customers:

    1
    Computer system design, networks, integration, general support.
  • http://ww2.justanswer.com/uploads/ZE/zeyank/2014-12-9_221254_zeyank.64x64.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1739
    A+ Certified Technician - 10 Years experience working with all types of computer systems.