Results 1 to 4 of 4

Thread: Excel 2010 sheet referencing issue

  1. #1
    Junior Member
    Join Date
    Jan 2008
    Location
    Cranebrook, NSW
    Posts
    143
    Thanks
    8
    Thanked 6 Times in 6 Posts
    Rep Power
    204
    Reputation
    130

    Default Excel 2010 sheet referencing issue

    Hey all,

    I have created lists for a drop-down box in Excel. The lists are in their own sheet. The idea is the user click the drop down, select a relevant category from the list, then input the amount in the cell to the right. This is working perfectly.... on this computer.

    I've saved the file and transferred it to another computer. When opening the file in the other computer, the two sheets (main sheet and lists sheet) are there, all the data is there, but the drop-down boxes have disappeared.

    "Show formulas" is off and the data type in the drop-down boxes is "General" (I've already Googled for a solution). So what is happening? Can anyone assist?

    tl;dr
    X-referencing cells in a different sheet doesn't work on any other computer than the one the file has been created on.



Look Here ->
  • #2
    Senior Member
    irritant's Avatar
    Join Date
    Nov 2014
    Posts
    1,684
    Thanks
    5,055
    Thanked 3,664 Times in 831 Posts
    Rep Power
    1636
    Reputation
    73270

    Default

    Are you also opening it in Excel 2010 on the other computer, or another version? Sometimes there are compatibility issues among the different versions of Excel.

    Does it ask to "enable content" in a yellow bar when you open it up? If so, choose yes.

    Are there any auxiliary (extra) files that might have to be copied along with this one?
    True freedom is the greatest gift a man can possess, yet is the one thing most easily and innocently given away, to crafty curses and binds cleverly disguised as blessings and gifts, in the pursuit of supposed achievement, status and power.

  • #3
    LSemmens
    lsemmens's Avatar
    Join Date
    Dec 2011
    Location
    Rural South OZ
    Posts
    10,585
    Thanks
    11,867
    Thanked 7,061 Times in 3,338 Posts
    Rep Power
    3153
    Reputation
    132592

    Default

    Are you using absolute or relative references? For moving between machines absolute referencing may be a problem unless both files are in EXACTLY the same folder structure. How are you referencing the relevant data? by cell or named range?
    I'm out of my mind, but feel free to leave a message...

  • #4
    Junior Member
    Join Date
    Jan 2008
    Location
    Cranebrook, NSW
    Posts
    143
    Thanks
    8
    Thanked 6 Times in 6 Posts
    Rep Power
    204
    Reputation
    130

    Default

    Turns out AdrianR was right. It was a version mismatch between Excel's. You'd think something as simple as cell referencing would work from version to version, but nooooooo.

  • 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
    •