Excel 2016 Mac Problem Bug Linking Cells Between Worksheets

Anonymous
2017-03-27T00:15:55+00:00

I have multiple worksheets in my excel document. I am trying to link data from a cell on worksheet 2 to a cell on worksheet 1. I enter "=" in the cell on Worksheet 1 and then click on Worksheet 2 and go to the cell that I want to reference/link. When I click on it, nothing happens in the cell on Worksheet 1. Yet the formula appears on a random cell in Worksheet 2. I have had no problem doing this before and the same workbook/document has multiple inter-sheet links from previous work I have done on it. All of a sudden this problem started happening today. Please help me figure this out. Very frustrating. Thank you. Brad.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2017-04-18T03:45:46+00:00

Hi Everyone,

I’d like to make a summary about this case, so other community members who come across this thread will easily find the useful information:

========================

Issue description:

The formula/value will be in a random cell after linking cells between worksheets when you store the workbooks in Dropbox.

More information:

Original, we have identified the issue will disappear when we go to the Dropbox settings and set the Dropbox badge to "Never show"..

Now, the issue should have gone away. It seems that the issue has been fixed by Dropbox in their latest release. For more information, refer to: 

https://www.dropboxforum.com/t5/Sharing-and-collaboration/Issue-with-Excel-files/m-p/213012#M13803

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​

========================

If you have any other questions, feel free to start a new thread and we will keep assisting you from there.

Regards,

Sky

Was this answer helpful?

5 people found this answer helpful.
0 comments

51 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-03T05:47:37+00:00

    Hi Brad,

    Please Change the step 6 to : click “Enter” **** to see the result.****(To explain this, the step 5 is a normal behavior to let you see the formula. So when you see the formula in BUS-EXPENSES worksheet, do not click back to Income worksheet, please directly press “Enter” in BUS-EXPENSES to tell Excel that you have finish the formula).

    If the issue persists, please give a screenshot about the version number. Because v.15.32 also has different updates packages. You can click Excel>about Excel to check the version number. For example 15.32 (170208).

    Thanks,

    Rena

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-04-02T17:12:37+00:00

    I tried this but then it just showed the linked formula in the cell as the result vs. the number. 

    Below is a run down of what I am doing and experiencing:

    1. Select Income Worksheet
    2. Select cell C14 (destination/result cell)
    3. Enter "=" 
    4. Select "BUS-EXPENSES" Worksheet Tab
    5. Select Cell G12 that has the info I want to appear on Income Worksheet C14 --- when I do it selects it, but it also then enters the formula (='BUS-EXPENSES'!G12) in cell C14 of BUS-EXPENSES Worksheet (same sheet) and the result on cell I13 on BUS-EXPENSES Worksheet (same worksheet) and this is where the problem starts
    6. I then select the "Income" worksheet and there is nothing in cell C14 where i originally entered "=" and the cell below it is now selected

    Now the thing is that I've tried this with different cells, some that are sums and some that are just numbers and it still happens. Also, the outcome is random - sometimes its like I've described above, sometimes it just shows the formula in a random cell and no result anywhere and the cells are always random. I have been working with this worksheet for a year for 2016 and no problems at all. Then I resaved it as 2017 and deleted some of the 2016 numbers and started copying over some of the 2017 numbers and then this started happening. 

    Here is the version of Office, etc.: Office 2016 for Mac - v.15.32

    Any help would be greatly appreciated. Thanks very much to everyone who is able to help me with this. 

    All my best, Brad.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-04-02T16:57:46+00:00

    Thanks Jim, but my office suite is fully up to date, so this isn't the issue.

    Was this answer helpful?

    0 comments
  4. Jim G 134.1K Reputation points MVP
    2017-03-30T16:36:52+00:00

    I don't think this question is about hyperlinks. I think it is about linked cell forumulas. I think this was a problem in an old build of Excel and that if you install updates the problem will most likely go away.

    Make sure your Mac has a working internet connection before checking for updates. Install Mac OS X updates followed by Office updates.

    Install Mac OS X updates first:

    To get Mac OS updates, go to the App store on your dock, and then click the Updates button to reveal available updates.

    Then Install Office Updates

    To get the update:

    1. Open any Office application:
    2. Make sure your Mac has a working internet connection
    3. Go to the Help menu and choose Check for Updates
    4. Let AutoUpdate check for and install updates
    5. Restart your Mac

    Was this answer helpful?

    0 comments