Linked spreadsheets take forever to open after Windows Update

[mskli]

Hello:

I have a spreadsheet (send.xlsm) that has thousands of links to another spreadsheet (calc.xlsm). I used to be able to open send.xlsm and it would open quickly then ask me if I want to update the links. Then I did a windows update and it takes forever for the spreadsheet to open. I noticed this with other similar spreadsheets on other computers as well. It's like it is trying to update send.xlsm (from the closed sheet calc.xlsm) and by the way it takes often 10 minutes and then it still asks me if I want to update the links. any idea what is going on?

 

[Burrgogi]

1) Are these files on a network drive at your workplace or are is this happening on your home PC?

2) Have you tried to open and save other MS Office applications (such as Word) to see if it's happening there as well?

 

[mskli]

only files with links have issues. I can save and it works as it should. Just bringing them up takes many minutes. I don't have word

 

[mskli]

on my home systems but not on a network drive

 

[Burrgogi]

There are some possible solutions listed here:

https://thegeekpage.com/microsoft-office-opening-too-slow/

Try them one at a time.

 

[mskli]

This recent issue is discussed in many places. here is one discussion:

Excel Workbooks with external workbook links loading extremely slowly

Using Excel via Office 365, I have noticed a dramatic increase in the amount of time required to open any member of a group of files, each of which have links..

techcommunity.microsoft.com