on 18/10/2002 9:21 AM, Brett Curtis at [EMAIL PROTECTED] wrote: You didn't say which operating system or version of Excel you are using.
It looks as though the preferences are set to manual calculation, and you expect it to calculate automatically. In Excel 98, go to "Preferences" in the "Tools" Menu, and select the "Calculation" tab. Set the option button for "Automatic". John > I am having difficulty in my Excel spreadsheet when copying a formula. > When I paste it to a group of cells, the results in those cells is the > same as the cell that I copied from although the formula is correct. > It is not until I go to each individual cell and click into the data > window and press enter does it formulate the correct data. > Hope this is not clear as mud. > TIA > > Brett Curtis > Master Window Cleaners > Perth, Western Australia > [EMAIL PROTECTED] > www.masterwindowcleaners.com > > > -- The WA Macintosh User Group Mailing List -- > Archives - <http://www.wamug.org.au/mailinglist/archives.html> > Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.html> > Unsubscribe - <mailto:[EMAIL PROTECTED]> > > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ > >
