Forum Discussion
Harish_Kumar830
Nov 06, 2019Copper Contributor
Source file not recalculated error
Hi, I have multiple files linked to one file in excel. I am facing a challenge that after a few days the files gives the error that some links are not updated because source file can not be recal...
JKPieterse
Nov 06, 2019Silver Contributor
Perhaps someone opens one of the source files with calc set to manual and then saves? Excel sets calculation mode based on the first file it opens. All subsequently opened files inherit the calc settings of the first one and that gets saved with those files too (!). So if a co-worker has a file he frequently uses which has calc turned off, he risks setting other files to manual calc too.
Harish_Kumar830
Nov 06, 2019Copper Contributor
Hi Jan,
Thanks for your reply. All colleagues open the online version of excel and enter the data there. Can it still impact? How do i avoid the same?
- JKPieterseNov 06, 2019Silver ContributorI would not expect it to impact it, but using linked files which are edited on-line might cause problems, I don't really know. How many source files are involved and what is the workbook which pulls from those files doing with the information?