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-04T19:01:33+00:00

    Philippe, I think you are correct. It was not happening before (other then some buggy stuff with the curser not selecting the right cell, but the one above it, etc.) and only started happening recently and I have autoupdates on. Wish we can go back to before this update. Seems kind of strange to have an update that makes things worse instead of fixing stuff.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-04-04T18:23:15+00:00

    It really is very frustrating to work under these problems ... I got in touch with the office people and they have not given me any solution!

    Please someone who has already been able to solve the problem that highlights us .....

    Thank you!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-04-04T16:05:12+00:00

    Hi

    I've updated with the latest office 365 pack (last week) and the same problem has suddenly happened.

    I did uninstall/install excel right now, and have still the same issue.

    when I want to insert an external value coming from another sheet from another excel file, and especially when there are pivot table in the sheet (even) the value which is reported is wrong, and is coming from the initial sheet itself.

    It sounds clearly like a bug implemented in the latest update.

    please advise when a patch will be provided.

    philippe

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-04-03T16:25:37+00:00

    Hi Rena,

    Thank you so much for replying to this as is been incredibly frustrating. I have actually been doing what you said - after I click on the cell that has the info I want to link, I then click enter. At that point random stuff happens:

    1. I just tried it now and it worked, but then I tried it again and
    2. Nothing appeared in the original cell on Income sheet, but the value I was trying to link to appeared on a random cell "D46" in the BUS-EXPENSES sheet and when I click on that cell - it shows the formula "='BUSINESS EXPENSES'!G26" which was supposed to go on the cell in the INCOME sheet. This is totally random - each time the result appears in a different cell. Sometimes the formula appears and not the result. Sometimes the formula appears in the cell I was trying to link to. Its like there is some kind of strange bug that is messing with this. 

    **NOTE: I've tried uninstalling entire office suite and reinstalling it and same thing happens. I've also tried rebuilding the entire spreadsheet in a new document and at first it is working fine, but then after about an hour or so, the same thing starts to happen. Other strange stuff happens too, like the cell above or below what I am trying to select being selected, etc. Its a very challenging experience. 

    Please see attached screen shot of the program version.

    I've also attached a screen shot of the random result that I got on the "BUS EXPENSES" work sheet. 

    Thanks again for all your help - I do appreciate it. 

    Was this answer helpful?

    0 comments