question

DadBodBatman-0202 avatar image
0 Votes"
DadBodBatman-0202 asked emizhang-msft commented

Issues with Excel not opening with link errors

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?

office-excel-itpro
capture.jpg (47.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DadBodBatman-0202,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

0 Votes 0 ·

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @DadBodBatman-0202,
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.





image.png (53.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.