 |
 | 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 / New Users / October 2006Copy/Paste Rows
When copy/pasting rows i notice some machines copy existing formulae & some don't Assume this is some sort of Excel settings Any Clues? I have never seen it nor am I aware of any such setting. (I don't know anything about xl2007 if that is what you are using).  SignatureRegards, Tom Ogilvy > When copy/pasting rows i notice some machines copy existing formulae & > some don't > > Assume this is some sort of Excel settings > > Any Clues? i actually have misled - i'll try again: when 'inserting' new rows - some machines (i have a class of 16) automatically insert any formulae - some don't? XL 2002 | I have never seen it nor am I aware of any such setting. (I don't know | anything about xl2007 if that is what you are using). [quoted text clipped - 9 lines] | > | > Any Clues? Hi Jethro There is an option Tools>Options>Edit>Extend List formats and Formulas but on my copy of XL2002 it does not seem to do anything when checked as opposed to unchecked. in XL2003, there is a Data>List option, which when invoked does add formulae as you add to a list of data. SignatureRegards Roger Govier >i actually have misled - i'll try again: > [quoted text clipped - 18 lines] > | > > | > Any Clues? i've looked at Tools>Options>Edit>Extend List formats and Formulas and it does seem to be the option but like yours, mine does nothing? it's seem to be a flaky option because it does work in 'some' of the machines in my class thanks anyhow | Hi Jethro | [quoted text clipped - 31 lines] | > | > | > | > Any Clues? If you have two instances of Excel running with a workbook open in each instance, you will get values pasted when copying from one workbook to the other. Close one instance of Excel and open both workbooks in one instance. Gord Dibben MS Excel MVP >When copy/pasting rows i notice some machines copy existing formulae & some >don't > >Assume this is some sort of Excel settings > >Any Clues?
|
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
|
©2008 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.