Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with pasting
Can anyone help me when I paste my formulas the pasted cells retain the values of the original cells - this has never happened before - have I pressed something I shouldn't? -- taffy1 ------------------------------------------------------------------------ taffy1's Profile: http://www.excelforum.com/member.php...o&userid=28596 View this thread: http://www.excelforum.com/showthread...hreadid=482622 |
#2
|
|||
|
|||
Problem with pasting
Sounds like your calculation is set to manual.
Reset it to auto by: <Tools <Options <Calculation tab, And click in "Automatic". Then check out this old post as to the reason you might have inadvertently caused this change in calc mode to occur: http://tinyurl.com/7ocux -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "taffy1" wrote in message ... Can anyone help me when I paste my formulas the pasted cells retain the values of the original cells - this has never happened before - have I pressed something I shouldn't? -- taffy1 ------------------------------------------------------------------------ taffy1's Profile: http://www.excelforum.com/member.php...o&userid=28596 View this thread: http://www.excelforum.com/showthread...hreadid=482622 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem when pasting text | Excel Discussion (Misc queries) | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Copying and Pasting between Workbooks | Excel Worksheet Functions | |||
Copying and Pasting between Workbooks | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |