Excel 2010 Numerical Accuracy

I have a large Excel workbook with VBA macros.   I runs it in both Excel 2010 64 bit and Excel 2016 64 bit.  However, the output results are different.   Any thoughts?
BW999Asked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
Do you use very large or very small numbers? If so this article may help. Don't miss the section at the end that talks about correcting precision errors.

Another possibility is that If you have VBA code in the workbook and you use variables defined as Double or Variant (which is the default if you don't explicitly define the type) you may be able to change them to Currency if you don't need more than 4 decimal places.
0
 
Martin LissOlder than dirtCommented:
Please describe the difference.
0
 
Ryan ChongCommented:
However, the output results are different.   Any thoughts?
could be formatting or data issues?

running both in same machine?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
BW999Author Commented:
The discrepancy is in some of the numerical results written to worksheet cells.   There are no problems with the formatting and both the Excel 2010 and 2016 workbooks are running with the same input datafile contained in a separate workbook.
0
 
BW999Author Commented:
Thanks
0
 
Martin LissOlder than dirtCommented:
You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.