Microsoft Excel Office 365 Compatability

I want to run some fairly complex (VB, VBA, Macros, formulas, Conditional Formatting, Outlining, etc. etc.) Worksheets that have been developed over 2 years in Excel 2010 32 bit environment.  I need to run them on a MAC or iPad.  So two questions;

1.) Is there a top end version of Office 365 Excel that will run with complete compatibility (i.e. macro execution) with the PC version of Excel 2010 or do you lose some of the capabilities when you move to the cloud version?  I hope not.

2.) Does the MAC version of Excel 2014 (latest?) run with compatibility with Excel 2010 on Intel?

My only other option is to run an emulation program on the iPad that "looks" at my desktop for execution.


Thank you in advance,

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Eoin OSullivanConsultantCommented:
1. Excel on Office 365 when running on your PC can support macros however running in a web browser on the cloud the "web" version does not support macros.

2. OSX latest version of Office 2011 (new version due soon) which includes Excel 2011 can support SOME VB macros.  Anything that requires access to the filesystem will require adjustment as OSX unix-based filesystem is quite different from Windows.  In summary macro-support is partial and definitely not all Windows Excel macros will work on Excel 2011 on OSX.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bright01Author Commented:
Good commentary.  Thank you for the info.  For now, I stay with 2010 Excel.


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.