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?

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,641 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 21,856 Reputation points Microsoft Vendor
    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