Issues with Excel not opening with link errors

DadBodBatman 1 Reputation point
2021-03-25T13:32:33.48+00:00

81613-capture.jpg

Ok, so I have an employee at work attempting to open a spreadsheet that was sent to her. If I open it, no issues. If other employees open it, no problem. When she opens it, she received the attached errors. The links do not update and do not work, but it's the data that is the issue. If I click on each cell, the data is there but to look at the sheet it's blank. If I change the view to "Page Break" view, you can see all of the data, but it's not ideal for looking at the data. When I change the view back to normal, it all disappears. If I go to the ribbon and change the "style" the data appears, but it's lost all formatting.

I've went through just about every setting in the trust center and cannot figure out why the sheet looks blank even though each cell has data in it. Also, clicking hide/unhide didn't work either.

Thoughts?

Microsoft 365 and Office Excel For business Windows
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2021-03-26T09:23:53.287+00:00

    Hi @DadBodBatman ,
    What version of Excel did you use?
    Did all users use the same version of Office?
    First I suggest you try to create a simple sample with links and test again, you can post the result here.
    Then I suggest you open Excel and go to File- Options- Advanced- General- uncheck Ask to update automatic links:
    81891-image.png

    Any updates please let me know and I'm glad to help you.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.