Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Frequent_User
 
Posts: n/a
Default Errors in copying formulas

When I copy a formula from one cell for set row to the following rows' cells
I get the same result as the original cell although the formulas are changing
as they should. I am not using absolute references in the formula. I have
never seen this before while working with excel.
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

ToolsOptionsCalculation.

Make sure "Automatic" is checked.

Gord Dibben Excel MVP

On Sat, 11 Dec 2004 15:03:02 -0800, "Frequent_User"
wrote:

When I copy a formula from one cell for set row to the following rows' cells
I get the same result as the original cell although the formulas are changing
as they should. I am not using absolute references in the formula. I have
never seen this before while working with excel.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel.exe has generated errors Mrich Excel Discussion (Misc queries) 7 December 31st 04 09:28 PM
In Exel 2000, stop the blank cells (with formulas) from printing. tonyoc Excel Discussion (Misc queries) 1 December 10th 04 12:38 AM
delete values in several cells without deleting the formulas dranreb Excel Discussion (Misc queries) 4 December 9th 04 01:15 AM
when displaying formulas, how to start a new line in the same cel. EL Excel Discussion (Misc queries) 1 December 7th 04 07:18 AM
Links in formulas change when another user runs a workbook L Mehl Excel Discussion (Misc queries) 2 November 27th 04 09:27 PM


All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"