+ Reply to Thread
Results 1 to 2 of 2

Excel 2011 Mac not responding to relative reference in filled down forumlas in some cells

  1. #1
    Forum Contributor
    Join Date
    09-23-2008
    Location
    Rhode Island
    MS-Off Ver
    Excel for Mac 2011 and 2007 on PC
    Posts
    265

    Excel 2011 Mac not responding to relative reference in filled down forumlas in some cells

    I have a formula that takes 20 characters from the Left of one cell to put them in the one next to it.

    the formula works fine if i enter it use A1 notation and when i fill down the formula changes cell references relatively, but the value delivered is that of the copied cell and not of the changed reference.

    so i tried simplifying it and just changed the one cell to a formula equal to the other cell, same problem. if i directly enter works fine but when i fill down it keeps giving the value of the original cell rather than the relative cell reference actually contained in the cell when i look at the underlying formula.

    i though maybe its a calculation thing, but i tried changing formats (which i thought were general already). i haven't set any value only key i'm aware of relative to fill down and it actually is filling with a correctly rleative referenced formula.

    to say it is driving me crazy wouldn't do it justice. i've never seen anything like it.

  2. #2
    Forum Contributor
    Join Date
    09-23-2008
    Location
    Rhode Island
    MS-Off Ver
    Excel for Mac 2011 and 2007 on PC
    Posts
    265

    Re: Excel 2011 Mac not responding to relative reference in filled down forumlas in some ce

    checked the preferences. somehow it had gotten itself on manual calculation and none of the various key combos that were supposed to force calculation did so. there use to be a calculate command in one of the menus but that is gone. I don't get why it has to be so obscure and you have to press 20 keys at once. it never occurred to me that the preference had acdtually set itself to manual but there must be an easy key combo for that that I hit bay accident.

    thanks for stopping by, anyway

    brian

+ 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. Relative forumlas when copying between workbooks
    By Sc0tt1e in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2018, 10:58 AM
  2. Access reference tools translator from VBA in Mac Excel 2011
    By jsherk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-13-2013, 07:25 PM
  3. Replies: 4
    Last Post: 01-03-2013, 12:25 AM
  4. How to Name cells with relative reference
    By venkatcute in forum Excel General
    Replies: 2
    Last Post: 08-14-2009, 06:30 AM
  5. Replies: 0
    Last Post: 11-15-2007, 02:35 AM
  6. Circular Reference Forumlas
    By acebrown in forum Excel General
    Replies: 1
    Last Post: 07-21-2006, 09:50 PM
  7. [SOLVED] How do I write macros with relative reference cells
    By trilogylynch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2005, 05:05 PM

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