excel copy paste problem

Thread starter elhann0n
Start date Mar 4, 2014
Tags

Apps Excel Formula

Sidebar

Previous Next Sort by votes

elhann0n

Estimable

Mar 4, 2014

copying the formula sum(a1:a3) from a4 to b4 does show sum(b1:b3) in the b4 cell, but, value is still the same as a4. Changing a character (eg deleting and reentering the 3 in sum(b1:b3)) gets the correct value.

Alabalcho

Judicious

Mar 4, 2014

Check "Recalculation" options, you might have turned them off.

You must log in or register to reply here.

Facebook Twitter Reddit Tumblr WhatsApp Email Link

Thread starter	Similar threads	Forum	Replies	Date
	Solved! Auto-Paste into Excell? How to?	Apps General Discussion	2	Oct 19, 2020
B	Solved! Formatted Print of Multiple Excel Worksheets	Apps General Discussion	2	Jan 10, 2019
N	Solved! Excel extraction (pattern)	Apps General Discussion	1	Jan 9, 2019
S	Simple RPG EXP formula BUT!, in MS excel (??) :(	Apps General Discussion	5	Oct 25, 2018
N	Hyperlinks not sorting in Excel	Apps General Discussion	2	Aug 15, 2018
L	My computer crashed and I need to open EXCEL on a different computer that doesn't have Microsoft Office on it. Is there a prog	Apps General Discussion	5	Jul 19, 2018
B	is "KeePass" trusted?	Apps General Discussion	4	Jun 26, 2018
K	Solved! Can't fully copy excel data collum range to another workbook	Apps General Discussion	1	Jun 23, 2018
R	Forgot password in Excel 2013	Apps General Discussion	1	Mar 7, 2018
T	unable to paste text on excel	Apps General Discussion	1	Nov 3, 2017
S	urgent help needed on copy and paste of cells	Apps General Discussion	3	Oct 5, 2016
M	Microsoft Excel Copy and Paste Changing my info	Apps General Discussion	1	Aug 18, 2016
T	cannot copy paste in excel 2010	Apps General Discussion	1	Jun 28, 2016
J	Is restrict copy paste possible in excel 2007	Apps General Discussion	2	Jun 25, 2016
A	Microsoft Excel 2010 Copy, Save & Paste Issue	Apps General Discussion	6	Mar 10, 2016
M	Copy Data, Insert Row, Paste Data into inserted row via Macro or other possible means in Excel sheet	Apps General Discussion	1	Sep 4, 2015
V	excel 2010 unable to copy paste large data	Apps General Discussion	1	Apr 16, 2015
L	Date copy/paste problem	Apps General Discussion	12	Nov 6, 2014
	How to Fix Copy and Paste Problems Associated with Microsoft Office	Apps General Discussion	0	Jul 28, 2013
L	Excel Copy Paste ISSUE HELP	Apps General Discussion	7	Mar 29, 2012

Similar threads
Solved! Auto-Paste into Excell? How to?
Solved! Formatted Print of Multiple Excel Worksheets
Solved! Excel extraction (pattern)
Simple RPG EXP formula BUT!, in MS excel (??) :(
Hyperlinks not sorting in Excel
My computer crashed and I need to open EXCEL on a different computer that doesn't have Microsoft Office on it. Is there a prog
is "KeePass" trusted?
Solved! Can't fully copy excel data collum range to another workbook
Forgot password in Excel 2013
unable to paste text on excel
urgent help needed on copy and paste of cells
Microsoft Excel Copy and Paste Changing my info
cannot copy paste in excel 2010
Is restrict copy paste possible in excel 2007
Microsoft Excel 2010 Copy, Save & Paste Issue
Copy Data, Insert Row, Paste Data into inserted row via Macro or other possible means in Excel sheet
excel 2010 unable to copy paste large data
Date copy/paste problem
How to Fix Copy and Paste Problems Associated with Microsoft Office
Excel Copy Paste ISSUE HELP