 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / April 2007copying formulas
when copying a formula from one cell using the cell drag down method to the cell below I get the value of the first cell. I have tried using the paste special function and following the general tips with no success. I have tried the method on another computer and it works, could there be something in the worksheet that needs to be changed  Signatureelsie It could be just the calc mode, inadvertently set to manual. Click Tools > Options > Calculation tab. Options are there. Ensure it's set to Automatic > OK. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > when copying a formula from one cell using the cell drag down method to the > cell below I get the value of the first cell. I have tried using the paste > special function and following the general tips with no success. I have > tried the method on another computer and it works, could there be something > in the worksheet that needs to be changed |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.