My excel file has a very large number of external links to a large number of different files. Frequently while working on this file, the cells with the external links will lose their data and return a #value error, a #ref error, or a zero in place of the correct values. I can fix the problem by opening the source files, but once all the source files are open my system runs very slow. Do you know why I'm losing this data in cells with external links and how I can fix it? Thanks for any help you can give.
Bookmarks