Forum Discussion
is Excel 2016 Power Pivot work on Excel 2010 by Shared Folder ?
Dears ,, I created Power Pivot in Excel 2016 and I imported the data from M Access (import & link), Both 2 files on Shared folder. The problem is: when other users open the Excel file by Excel 2010...
PowerPivot on 2010 is not compatible with Power Pivot on later versions
thank you for your quick respond
Do you think upgrade to 2016 is good solution?
Do you think upgrade to 2016 is good solution?
Abachee,
In general good or bad depends on goals. If using Excel actively, plus with BI functionality - yes, no doubt. That costs some money, but you'll have more powerfull instrument in hands which saves your time. Especially if it's part of Office 365 subscription.
If only collect daily expenses or like - 2003 will be more than enough.
Real life is somewhere in the middle, that's your decision how to compromize. In any case, if you are in distributed environment better to have same (desirably modern one) version for everyone.