Forum Discussion
Need help to get Powerpivot download file for Excel 2010, 32 bit
Power Pivot for Excel 2010 is available here https://www.microsoft.com/en-us/download/details.aspx?id=7609 , for 32 bit system download x86 file.
About time of shifting from 2010 to 2013 data model architecture was changed, I'm not sure if you use 2010 version it will be compatible with more latest version or not. If open 2010 version on later one Excel asks to convert data model, backward compatibility is not available. At least as it was long ago, didn't touch 2010 for a long while.
Dep[ends on goals, if use Excel as simple calculator it doesn't matter which one to use.
In general, these days 32 bit may be needed if only you expect compatibility issues (have old third-party add-ins which are not supported any more or like cases). Otherwise 64 bits.
Subscription model (Office365) provides full-functional regularly supported software compare to on-premises one (I mean parallel versions, Home in both cases, Enterprise in both cases, etc). For example, some functionality available now for all level of Office365 subscribers is not available even in Excel 2019 and could be only for Excel 2022 or so.
Another story do you need such functionality or not. If you work with Excel regularly - most probably yes. If if you don't see that now, such need may appear any day in future.
SergeiBaklan All are very good points. So far, only the regular data modeling and financial models, and I have not run into compatibility issues. But I will pay attention in the future, certainly. In the groups that I have been working with, I have been the one care the most so far, and the rest are using just the basic.
Again, I greatly appreciate your insight and the help!