Excel - paste special formulas doesn't work

B

beruf3

New Member
Joined
Nov 20, 2015
Messages
43
I have Excel 2007, when I paste special formulas from one cell (let's say A1) to all other cells in A column,
it copies formulas OK, but it shows value of what formula calculated for A1. Then, I need to go to every single cell and press "Enter" to get the correct value.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
I found it myself. Calculation options were changed to "manual". I don't know how. But I switched it back to "automatic".
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
Excel script using if statement to copy/paste special values for specific rows
Replies
2
Views
195
kcampbell675
K
E
  • Solved
Copy/Paste Special based on value in different cell
Replies
8
Views
629
kevin9999
K
T
  • Question
Macro to fill down for a range of cells
2
Replies
11
Views
469
Fluff
Fluff
L
  • Question
VBA Code to paste special values over a cell depending on another cells value....
Replies
1
Views
686
Micron
M
S
  • Question
Copy/paste special values of Excel table based on cell value
Replies
2
Views
162
stacey_t
S

Forum statistics

Threads
1,215,170
Messages
6,123,422
Members
449,099
Latest member
COOT

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top