Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I have set up my spread sheets with Automtic calc set for Excel…

Customer Question
I have set up my...
I have set up my spread sheets with Automtic calc set for Excel 2003. Loaded Excel and the spread sheets on to a new laptop with Win 7. For some reason, the spread sheets are not Automatically calcutaling. Have to hit F9 or re-check the Automatic calc once an entry is placed in a cell. Using Excel with a data-logger, but have never had this problem before. Thank you. Gabor Lazar.
Submitted: 8 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 7 minutes by:
6/29/2010
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago
John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
Experience: Vast experience in Excel programming and business solutions
Verified

Hi,

 

Which Excel version are you running on Windows 7?. And how exactly did you set up automatic calculation?

 

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
2003 Tools, calculation, and selected Atuomatic. Windows Premium
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Could you close all Excel files and applications, then download, save and open this file.

 

FILE

 

Then type 9 in A1 and tell me what cell B1 displays without pressing F9 or changing any setting.

 

 

.

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
B1 did NOT change.
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Ok, with only that file open go to Tools > Options > Calculation and click on Automatic, then OK.

 

Does the number in B1 change? Try typing other numbers in A1

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
YES
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

So there is no problem with your Excel application nor with your operating system. The problem is most likely in that file. If you want to send it to me I will be happy to look at it.

 

 

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago

The file(s) seem to have only the problem on the laptop we are suing with the data-logger. The file(s) have been used on several other laptops and desktops and we never saw this problem before. I am not on that laptop now.

Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Well in that case you need to run the same test that I gave you on the other system. Do that and get back to me with the finding and we will take it from there.

 

In the meantime thank you for clicking Accept if you are satisfied with the assistance.

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago

The guys in the field today ran that same test. The cell would only calculate if they hit F9 or if they went back and selected Automatic after entering a value in a cell.

Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

No, I need you to run the same file that I sent you on the other computer. That is the whole point of sending you the file.

 

John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
Experience: Vast experience in Excel programming and business solutions
Verified
John D and 87 other Programming Specialists are ready to help you
Ask your own question now
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Thanks.

 

Please make sure to bookmark this page so you can get back to me later to continue

 

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask John D Your Own Question
John D
John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Vast experience in Excel programming and business solutions

John D is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

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 CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

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!!!!

AlexLos Angeles, CA

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.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

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.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I have macros that were developed in Excel 2003 or older.
I have macros that were developed in Excel 2003 or older. I have Excel 2010 now and have had issues when running those macros in 2010, it causes Excel to crash and restart or close Excel. I have had s… read more
Bryan
Bryan
735 satisfied customers
I have an excel workbook with around 15 sheets. Each sheet
Attachment: 2012-08-02_224053_ccc_training_evaluation_survey_data_collection_3.xlsx I have an excel workbook with around 15 sheets. Each sheet has summary numbers from a training. The person who enter… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Regarding Excel: To add data to a spread sheet, how do I
Regarding Excel : To add data to a spread sheet, how do I insert it into an existing document in a new cell?… read more
jatechexpert
jatechexpert
Master\u0027s Degree
1 satisfied customers
We just converted our Office from 2003 to 2010 recently and
We just converted our Office from 2003 to 2010 recently and all of the Excel spreadsheets that had cell level ptotection will no longer accept the password XXXXX be able to key into the cell. I can ma… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Im not a very knowledgeable excel spreadsheet user and could
I'm not a very knowledgeable excel spreadsheet user and could use some help: I have a large number of rows, consisting of results for a series of physical fitness tests. The last cell in each row is a… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
I have a spread sheet that I use for my 501C Mens orginazation.
I have a spread sheet that I use for my 501C Mens orginazation. The spread sheet was configured using the Excel 97 program by my predecessor and had functions in many of the cells. I loaded on to my l… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I have written a VBA program to create a quote sheet from
I have written a VBA program to create a quote sheet from an excel calc sheet. Both sheets are in the same workbook. I have a Logo on the main calc sheet that I need to put on the quote sheet in a cel… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Cell links (Excel 2007) between sheets in workbook stoped updating.
Cell links (Excel 2007) between sheets in workbook stoped updating. MSFT Office diagnostics say no problems found… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
How would I average productive hours for the week. I would like to average only the days w
How would I average productive hours for the week. I would like to average only the days with more than 1 hour. The AverageIf formula I used gave me a NAME error in Excel 2003: =_xlfn.AVERAGEIF(C36:O3… read more
Raj
Raj
SAP ABAP Consultant
Master\u0027s Degree
27 satisfied customers
The problem relates to the macro in column B of paysheet lastTimeslot
The problem relates to the macro in column B of paysheet =lastTimeslot in 2010 I double click on the cell and hit enter the data appears, on 2007 it works and doesnt not sure why its inconsistent. Wha… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
hi My excel formulas all result in zero, and automatic fromula
hi My excel formulas all result in zero, and automatic fromula calc is still on. Even if i double click on a formula done before the corruption that is showing a numeric answer to check what cells it … read more
Jason Jones
Jason Jones
AAS Information Technology
6,329 satisfied customers
I have a Excel 2007, I have a schedule document I have created
I have a Excel 2007, I have a schedule document I have created that does calculating and some formula functions that use on a daily basis. I need to incorporate the data from a 2003 Excel data sheet t… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I am using Microsofts excel Forecast formula. I have spreadsheet
I am using Microsoft's excel Forecast formula. I have spreadsheet with 450 lines of data each of which needs to be forecast for a future time period. If you are familiar with the Forecast formula it u… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I have a 3 variables in 3 cells. Variable 1 increases in steps
I set a value of 25000 to B102 first, perform goal seek to set B111 to 0 by changing B103. Record the values of B12, B21, B29, B38, B43, B59, B70, B82, B93 to a row in new sheet I will now set B102 to… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
Excel VBA Macro to move to another cell after entering text
Excel VBA Macro to move to another cell after entering text or numbers in a predetermined manner.… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I built a spreadsheet that analyzes data sets that I get.
I built a spreadsheet that analyzes data sets that I get. Currently I am opening my template, pasting in the data set, letting it calculate (takes around 20 secs because the template is 20Mb), copying… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I have Excel 2007 on a work PC which I use to calculate my
I have Excel 2007 on a work PC which I use to calculate my companies bids. Since switching over from Excel 2003 I have had an intermittent problem with the bid form, and other docs with calcs, not aut… read more
John D
John D
Bachelor of Science - Engineering Consultant
Bachelor Degree in Engineering
9,666 satisfied customers
I live in an apartment of 25 flats. We share a central heating
I live in an apartment of 25 flats. We share a central heating system and I need to apportion the main bill into 25 parts. I have produced a spread sheet to do this. All owners pay a standing charge s… read more
Karl Everest King
Karl Everest King
Web Designer, Programmer
Vocational, Technical or Trade Scho
224 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x