+ Reply to Thread
Results 1 to 3 of 3

Copy Paste of precedent cell [B3] w/ formula cell [C5] (=$B$3) acts differently 2003vs2016

  1. #1
    Registered User
    Join Date
    03-08-2005
    Posts
    1

    Copy Paste of precedent cell [B3] w/ formula cell [C5] (=$B$3) acts differently 2003vs2016

    In Excel 2003, copying
    B3 which contains 23 and C5 which contains =$B$3 and pasting seven rows down gave
    B10 which contains 23 and C12 which contains =$B$12
    In other words, when the precedent cell and the formula were copied at the same time, the new pair had the same spatial relationship as before, looking two up and one cell to the left

    In Excel 2016, the same copy and paste gives
    B3 which contains 23 and C5 which contains =$B$3 and pasting seven rows down gave
    B10 which contains 23 and C12 which contains =$B$3
    In this case the pasted formula ignores the cell two up and one to the left, and instead looks nine rows up and one to the left.

    Microsoft thought they were solving a flaw, but I had found it very useful in transferring things as a group without having to redefine the spatial relationship. How can I emulate the behavior from Excel 2003 in Excel 2016???
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    83,494

    Re: Copy Paste of precedent cell [B3] w/ formula cell [C5] (=$B$3) acts differently 2003vs

    The Excel 2016 behaviour is correct. Change the cell reference to =$B3 and try again.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Copy Paste of precedent cell [B3] w/ formula cell [C5] (=$B$3) acts differently 2003vs

    I cannot recreate your problem

    from Ex95, 97 & 2016 all is $B$3 to $B$3 not $B$12

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy - Paste entire table into one cell using active cell formula
    By alexgoaga in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2017, 10:14 AM
  2. [SOLVED] Macro acts differently when ran directly or through a command button
    By Caturne3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2015, 09:28 AM
  3. Copy, Paste formula output from one cell to another cell with values
    By MEYYAPPANS in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-04-2015, 01:34 PM
  4. [SOLVED] Formula: Paste value to cell and copy itself to cell below
    By MIGARDEIN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2015, 09:31 AM
  5. [SOLVED] Copy/Paste cell above the formula or active cell
    By hockeysimo09 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2014, 10:35 AM
  6. Excel Macro Acts Differently on Different Computers, even with same version
    By dbaft in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2011, 07:58 AM
  7. [SOLVED] FORMAT SECTIONS OF CELL FORMULA DIFFERENTLY
    By Takeadoe in forum Excel General
    Replies: 3
    Last Post: 07-13-2006, 11:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1