| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy function with Excel 2003 not performing correctly
New job and new laptop running Office 2003. Very expereienced Excel user.
However, using Excel on 3 different computers are giving issues in particular with copying formulas. I want to click on cell and drag to next column over. Data is different in both columns, formula copies over properly but sum is tha same as the original cell. I can do this multiple times with same bad result. Is there a setting somewhere that I am missing? Have no problems with laptop at home which is running 2003 as well. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy function with Excel 2003 not performing correctly
Toolsoptionscalculation, set it to automatic
-- Regards, Peo Sjoblom "wtztips" wrote in message ... New job and new laptop running Office 2003. Very expereienced Excel user. However, using Excel on 3 different computers are giving issues in particular with copying formulas. I want to click on cell and drag to next column over. Data is different in both columns, formula copies over properly but sum is tha same as the original cell. I can do this multiple times with same bad result. Is there a setting somewhere that I am missing? Have no problems with laptop at home which is running 2003 as well. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy function with Excel 2003 not performing correctly
Tools Options Calculation Automatic
-- Gary''s Student - gsnu200728 "wtztips" wrote: New job and new laptop running Office 2003. Very expereienced Excel user. However, using Excel on 3 different computers are giving issues in particular with copying formulas. I want to click on cell and drag to next column over. Data is different in both columns, formula copies over properly but sum is tha same as the original cell. I can do this multiple times with same bad result. Is there a setting somewhere that I am missing? Have no problems with laptop at home which is running 2003 as well. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Size Between Worksheets when performing a copy and paste | Excel Discussion (Misc queries) | |||
| Excel 2003 does not open html file correctly | Excel Discussion (Misc queries) | |||
| Excel 2003 Subtotals not working correctly | Excel Worksheet Functions | |||
| Excel 2003 doesn't filter correctly | Excel Discussion (Misc queries) | |||
| Macros not performing correctly | Excel Discussion (Misc queries) | |||
Linear Mode
