User Profile
rjustinm
Copper Contributor
Joined May 27, 2024
User Widgets
Recent Discussions
Re: Excel Workbooks with external workbook links loading extremely slowly
It probably still won't totally work for you but you *can* use the array reference as part of an IF statement, in the form IF(ExternalWorkbookReference="","",ExternalWorkbookReference). This will leave all of your imported empty cells as empty cells but will still not increase load time.3.1KViews0likes0CommentsRe: Excel Workbooks with external workbook links loading extremely slowly
Certainly not a long-term fix for all situations, although it does help for instances where entire ranges of cells are being referenced. It seems like every instance of a formula referencing an outside workbook increases the loading time, so any way to reduce the number of formulas helps. As for what caused this to happen and why it has not been addressed, I have no idea. I'm sure there are many, many users being affected by this, and many probably have not yet made the connection between slow load times and external references. Needs to be resolved ASAP.3.1KViews0likes0CommentsRe: Excel Workbooks with external workbook links loading extremely slowly
Great information! I tested this with a workbook linking to 14 other workbooks, and the load time was effectively instant. The issue with empty cells is not relevant for my needs, but at the very least the workbook opens quickly enough to be usable, and if empty cells are an issue they could be dealt with on the imported side. While I would still be fascinated to learn why this change of performance occurred so suddenly after many years of consistency, I'm really glad to have a workable solution. Perhaps Excel is just built to favor working with arrays now. At any rate, hope this helps everyone else looking for a solution as well.3.3KViews0likes0CommentsRe: Excel Workbooks with external workbook links loading extremely slowly
I've found the same, if the workbooks are open they work as before, no significant lag of any kind. The delay is simply in opening the document. And in my case at least, some documents link to quite a few other workbooks; opening every single one would be beyond inconvenient. The whole point is to consolidate various data into a single source to provide quick overviews, at least the way I use it. Thanks for the input!3.3KViews0likes0CommentsExcel 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 to other workbooks. These are files that I open daily, and have opened daily for quite some time. Each of them have links to other workbooks, very simple in nature, simply referencing cells in the other workbooks; no calculations are performed in the reference. The files themselves are fairly small, on the order of 2 MB. They previously opened in 2-8 seconds, I would guess. Now, they can take up to 30 minutes(!) to open. I noticed this first on the morning of May 25th. No 365 updates are shown for the 24th or 25th; however, I did have a new message from Windows on my computer that morning letting me know that service for Windows 10 would be ending soon. All other Excel files open totally as normal. Anyone have ANY idea how to make this make sense?Solved5.5KViews1like15Comments
Recent Blog Articles
No content to show