Issues with Excel not opening with link errors

DadBodBatman 1 Reputation point


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.


Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,346 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 10,616 Reputation points Microsoft Employee

    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:

    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.

    No comments