Thanks John for your reply
I am using OSX Excell X
and the method there is the same as 98 so Thank you for solving my
problem
Regards
Brett
On Friday, October 18, 2002, at 01:07 PM, John Taylor wrote:
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/
Brett Curtis
Master Window Cleaners
Perth, Western Australia
[EMAIL PROTECTED]
www.masterwindowcleaners.com
