I have an Excel file with links and many formulas, the formulas are not making slow the excel sheet, I can work with it very fluid but for a while gets freeze for 5-6 mins.

I am working with files in a lan network.

I’ve tried to deactivate automatic refresh from workbook links and also in trust center, external content, disable automatic update of workbook links but still the same.

My solution is to update the values, remove the links, save as in another file and then work.

Does anybody know the reason of why excel is getting freeze(not answering) for some  minutes and then ok?

​I have an Excel file with links and many formulas, the formulas are not making slow the excel sheet, I can work with it very fluid but for a while gets freeze for 5-6 mins. I am working with files in a lan network. I’ve tried to deactivate automatic refresh from workbook links and also in trust center, external content, disable automatic update of workbook links but still the same. My solution is to update the values, remove the links, save as in another file and then work. Does anybody know the reason of why excel is getting freeze(not answering) for some  minutes and then ok?   Read More

​