Link to home
Create AccountLog in
Avatar of BW999
BW999Flag for United States of America

asked on

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?
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Please describe the difference.
However, the output results are different.   Any thoughts?
could be formatting or data issues?

running both in same machine?
Avatar of BW999

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of BW999

ASKER

Thanks
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