 |
 | 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 / April 2007Formulas inserting from nowhere??
I'm working on a spreadsheet that I got from someone else (who got it elsewhere originally, so they don't know the answer either). I type a value in a cell and other cells automatically calculate. No big deal - except there are no formulas in those cells until I type a value in the first cell! There are no macros, no formulas in other unused cells, and no conditional formats that I can find. How does it do this??!? Ed Did you look for event macros under that worksheet? And you sure that any formulas weren't hidden by format|conditional formatting? Or even format|cells|protection tab|locked and hidden checked? > I'm working on a spreadsheet that I got from someone else (who got it > elsewhere originally, so they don't know the answer either). I type a [quoted text clipped - 6 lines] > > Ed  SignatureDave Peterson Isn't this just the Extend list formats and formulas option? Tools > Options> Edit > Extend list formats and formulas. Not that I would know only having XL97 <g> SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > Did you look for event macros under that worksheet? > [quoted text clipped - 13 lines] >> >> Ed Could be. (I've never had any luck with this feature. I don't understand its rules, so I don't use it!) Might be Data|List, too? (Data|List was added in xl2003.) > Isn't this just the Extend list formats and formulas option? > [quoted text clipped - 33 lines] > > > > Dave Peterson SignatureDave Peterson Hi, Sandy. > Isn't this just the Extend list formats and formulas option? > > Tools > Options> Edit > Extend list formats and formulas. Well, that is checked. I never knew that exisited!! *************************** Extend formats and formulas to additional rows By default, Microsoft Excel automatically formats new data that you type at the end of a range to match the preceding rows. Excel also automatically copies formulas that have been repeated in the preceding rows and extends them to additional rows. Note In order to be extended to new rows in the range, the formats and formulas must appear in at least three of the five preceding rows. *************************** That's pretty handy! Can it be workbook-specific, I wonder? Or is it checked or unchecked for all workbooks in each session? Ed > That's pretty handy! Can it be workbook-specific, I wonder? Or is > it checked or unchecked for all workbooks in each session? I think that it is workbook specific but as I said, having only XL97 I don't have it at all. Perhaps one of out *posh* friends with later versions can tell us, or you could of course experiment for yourself and then YOU could tell Us. <g> SignatureRegards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk Hi Sandy As far as I can see, it is applicable to the Excel session i.e all workbooks loaded follow the pattern set under Tools>Options, and like Calculation mode, the setting on the first workbook opened, sets the value for that session unless you alter it. SignatureRegards Roger Govier >> That's pretty handy! Can it be workbook-specific, I wonder? Or is >> it checked or unchecked for all workbooks in each session? [quoted text clipped - 3 lines] > versions can tell us, or you could of course experiment for yourself > and then YOU could tell Us. <g> Thank you Roger. I will try to remember that until I manage to upgrade to a later version - I just hope that my memory is THAT good. <g> SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > Hi Sandy > [quoted text clipped - 10 lines] >> versions can tell us, or you could of course experiment for yourself and >> then YOU could tell Us. <g> >I just hope that my memory is THAT good. <g> I'm sure it will be - now what was your name?<bg> SignatureRegards Roger Govier > Thank you Roger. I will try to remember that until I manage to > upgrade to a later version - I just hope that my memory is THAT good. [quoted text clipped - 15 lines] >>> later versions can tell us, or you could of course experiment for >>> yourself and then YOU could tell Us. <g>
|
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.