Solved

Excel formual only works when I press Enter

Posted on 2014-07-25
3
233 Views
Last Modified: 2014-07-28
Hello Experts Exchange
I currently have a Excel 2010 spreadsheet that has formulas in it that only work when I go in to the cell and press enter.

The formulas in the cells are like the following;
='J:\07\AC4\Moulding\[MouldingRed561.xls]Production'!AD141+'J:\07\AC4\Moulding\[MouldingBlue561.xls]Production'!AD141+'J:\07\AC4\Moulding\[MouldingYellow561.xls]Production'!AD141

Is there a way to get the formulas to update automatically?

Regards

SQLSearcher
0
Comment
Question by:SQLSearcher
3 Comments
 
LVL 14

Expert Comment

by:Vikas Garg
ID: 40219042
Hi,

It is not related to SQL ...
0
 
LVL 19

Assisted Solution

by:helpfinder
helpfinder earned 200 total points
ID: 40219101
try to press CTRL+ALT+F9 if the formulas will be recalculated.
also check if your cell formatting is not text, so you can try to change to general and then CTRL+ALT+F9 to recalculate formulas
0
 
LVL 13

Accepted Solution

by:
duncanb7 earned 300 total points
ID: 40219104
I think you need to stop auto recalculation on Excel cells from automatic to manaul
as the instruction at this site
 http://www.dummies.com/how-to/content/controlling-excel-2007-formula-calculations-manual.html

After that, you can click cell and press enter, the cell will calculate it again

Duncan
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Video by: Zack
Viewers will learn about various customizable options in Excel 2013.
Viewers will learn the basics of using filtering and sorting in Excel 2013.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now