Forum Discussion
Office subscription - is my Excel local or cloud?
In general, if previous version is 2010 in some scenarios it could be bit faster compare to latest 365, but not dramatically. I may only guess that in your case the reason in supporting of dynamic arrays. If in previous version it calculated current row/column (implicit intersection) now it calculates entire array defined in your formula. On the other hand if so you shall have different results compare to previous version.
Anyway, the question is bit abstract. If you could provide small sample file it'll be easier to find the reason. Abstract answer - 365 has about the same performance as previous versions, if not better, depends on with what to compare.
Is your file local or in cloud depend only where you keep it - 365 doesn't copy local file on OneDrive before opening it. 365 means only you have subscription model with apps included into the subscription, all the rest is the same.
SergeiBaklan I really can't provide the file itself, as it contains professional, and in some cases personal, email addresses.
But I should note - this is a static file. No formulas, no macros, no lookups...nothing calculated at all. Just data. And not very much of it. Less than 1mb.
I keep the file stored locally. I even moved a copy to another local drive and tried opening that version. Still took 12 or more seconds.
Thanks for trying to help.DKirby58 , thanks for the clarification. If no one formula and no one PivotTable or like I have no idea what it could be. At least in my practice I see no significant delays in files loading.
