Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Relative Cell Referencing in MS Excel

When I copy and paste formulas, the relative cell referencing is not
working. It is copying the same formula all the way down and I don't
have any absolutes in my formulas. What could be the problem?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Relative Cell Referencing in MS Excel

Most common cause of this is that calculation is set to manual.

ToolsOptionsCalculation.

Set it to Automatic.


Gord Dibben MS Excel MVP

On 21 Feb 2007 12:56:28 -0800, wrote:

When I copy and paste formulas, the relative cell referencing is not
working. It is copying the same formula all the way down and I don't
have any absolutes in my formulas. What could be the problem?


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
Relative vs Absolute referencing of Workbooks Ronald Dodge Excel Worksheet Functions 4 September 26th 06 11:34 PM
Relative referencing in Microsoft Excel between worksheets SeveranceD Excel Discussion (Misc queries) 3 September 8th 06 12:39 AM
Relative column referencing within formulas Alistair Excel Discussion (Misc queries) 4 February 23rd 06 06:38 PM
How do I turn off relative cell referencing in excel? Glenn New Users to Excel 1 April 13th 05 04:06 AM
macro relative referencing harriet Excel Discussion (Misc queries) 5 February 15th 05 02:40 PM


All times are GMT +1. The time now is 11:54 AM.

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

About Us

"It's about Microsoft Excel"