Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by SQLSearcher
at 2024-07-25 03:09:58
ModifyPoint:500 Replies:3 POST_ID:829100USER_ID:11980
Topic:
SQL Server 2008;;Spreadsheet Software
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: 7AC4Moulding[MouldingRed561.xls]Production'!AD141+'J: 7AC4Moulding[MouldingBlue561.xls]Production'!AD141+'J: 7AC4Moulding[MouldingYellow561.xls]Production'!AD141
Is there a way to get the formulas to update automatically?
Regards
SQLSearcher
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: 7AC4Moulding[MouldingRed561.xls]Production'!AD141+'J: 7AC4Moulding[MouldingBlue561.xls]Production'!AD141+'J: 7AC4Moulding[MouldingYellow561.xls]Production'!AD141
Is there a way to get the formulas to update automatically?
Regards
SQLSearcher
Accepted Solution
Expert: duncanb7 replied at 2024-07-25 03:45:51
300 points EXCELLENT
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
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
Assisted Solution
Expert: helpfinder replied at 2024-07-25 03:44:59
200 points EXCELLENT
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
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
Expert: Vikas Garg replied at 2024-07-25 03:12:21
Hi,
It is not related to SQL ...
It is not related to SQL ...
