Forum Discussion
Solved
#Value error from external links only if using diff version of Excel
I've got a client having issues with Excel and sharing workbooks with links in them.
The short version is the file is an .xls file created in Excel 2013, with SUMIF formulas linking to another ...
- I just tried with Excel 2010 and 2016 (haven't got 2013):
- If saved in 2010 and opened in 2016 a full recalc is done
- If saved in 2016 and opened in 2010 no calc is done.
I'm afraid not much can be done about this. If Excel detects that a workbook has last been opened in an older version of Excel it will always recalculate the workbook. This has been the case for various versions of Excel so no difference in behaviour, other than that your users have to deal with more than one version of Excel in your organisation.
- Thanks Jan.
Is the same true if someone opens the workbook in an older version of Excel? I.E. created and saved in a newer version, opened in a prior version? They tell me it only happens when the version isn't the same, and not necessarily when it's newer, sometimes a user had an older version. (as they roll out Office 2016, they find this happens to 2013 users).- I just tried with Excel 2010 and 2016 (haven't got 2013):
- If saved in 2010 and opened in 2016 a full recalc is done
- If saved in 2016 and opened in 2010 no calc is done.- Thanks, that's helpful. It seems this client has it going both ways but I need to test that to validate if my results match yours.
