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: Oldest
Most helpful Newest Oldest
  1. 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
  2. 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
  3. Anonymous
    2017-04-05T04:33:16+00:00

    I found that if I use the = for linking cell in Worksheet#2 from worksheet#1 the formula is in one of the cells in the Worksheet#2. It does not reflect in the worksheet#1. 

    Further in Office 2011 I could copy the formulas of a cell from one worksheet to another. This is also not working now.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-04-05T06:40:10+00:00

    Hi Bradr2720,

    We have tested this on our side, but we couldn't reproduce the issue now. To move forward, please provide the following information for our analysis:

    1.Your OS version

    2.Usea safe mode and check if the random issue reoccurs.

    3.Create a new workbook in local including some worksheets and see if the issue occurs.

    4.Perform the following steps again and record a video till the issue happens for our check.

    a. Select the Income Worksheet

    b. Select cell C14 (destination/result cell)

    c. Enter "="

    d. Select "BUS-EXPENSES" Worksheet Tab

    f.  Select Cell G12 that has the info you want to appear on Income Worksheet C14  -> click Enter till the issue happnes.

    Note: after you click the enter key, the right symptom is that the cursor will be in C15 of the Income Worksheet.

    @Philippe,

    1.Does the issue happen when lining the cell in a worksheet of the same workbook?

    2.Do you experience the same behavior " the formula/value will be in a not correct cell randomly after performing steps a~f "? If not, can you describe more details?

    3.Your Office version and OS version

    @Ruben,

    1.Please double confirm if your situation is the same as Bradr2720's.

    2.Try steps a~f mentioned above and let us know the result happened on your side.

    3.Is it a random or certain issue on your side?

    4.Your Office version and OS version

    5.Since you have contacted Office people, please share the Service Request number for our check. You can provide it in private message: https://answers.microsoft.com/en-us/privatemessages/list

    @Rajshekar,

    If you'd like to link the cell in Worksheet2 from worksheet1, here are the steps:

    1.Go to Worksheet2 ->  select any cell, such as B2 -> type "="

    2.Go to Worksheet1-> select any cell, such as A1 -> click enter

    3.Now, the cursor should be in B3 by default. If you click B2, you will find the Formula= worksheet1!A1

    In addition, Bradr2720 are talking the formula/value will be in a not correct cell randomly after performing steps a~f mentioned above. If you are not in this situation, please post a new thread and we will keep assisting you from there

    Regards,

    Sky

    Was this answer helpful?

    0 comments