Author Topic: microsoft office  (Read 711 times)

Offline santoshlv426

Re: microsoft office
« Reply #15 on: May 11, 2018, 09:28:00 AM »
I've been down this road with spreadsheet packages in the past. Microsoft has purposly changed the programming code since Office 2010.
Office 2010 and beyond is not compatible with any other office program on the market - nor earlier versions of office.
The best alternative to Excel 2016 for example is Excel 2013 or 2010.
Even Corel office is not 100% compatible with MS 2010 and I actually engaged with Corel direct on this up to a point of sending them an Excel (.xlsm) workbook to troubleshoot, which eventually they had to admit that the Corel was not 100% when it comes to coding in VBA specifically.
Take the plunge, spend the money and get Office 2016.
One actaully has no choice

Offline Trompie67

Re: microsoft office
« Reply #16 on: May 11, 2018, 10:09:48 AM »
All my DCF valuation spreadsheets for commercial/industrial property valuations as well as the spreadsheets for Basel property risk profile evaluations we did for the bank we were contracted to were done in Office 2007.

2010 (what I currently use) must have automagically upgraded them by itself, as they all still work 100%. Completed a rolling 3, 5 & 10 year DCF valuation on a commercial property with 118 tenants in April & all permutations worked perfectly. in which case I can only say Viva MS! ;)

I'll try it on 2016 that's on the wife's laptop over the weekend & see if it borks or not. I'm still yet to see any real useable difference between 2007, 2010 & 2016.
*Insert profound or witty phrase here*

Offline santoshlv426

Re: microsoft office
« Reply #17 on: May 11, 2018, 10:29:42 AM »
@ Trompie.
Excel spreadhsheets prior to 2010 - anything created on 2007 or earlier is imported on 2010 and beyond no problem, but you cannot GO BACK.
One can't create a complex VBA (.xlsm) workbook and try it on 2007.
You'll have to convert it to 2007 (.xlsx) and then it will lose features. This is the point, .xlsm files are not recognized by older versions and .xlsm cannot be 100% converted to .xlsx or .xls.

Offline Trompie67

Re: microsoft office
« Reply #18 on: May 11, 2018, 04:28:58 PM »
@ Trompie.
Excel spreadhsheets prior to 2010 - anything created on 2007 or earlier is imported on 2010 and beyond no problem, but you cannot GO BACK.
One can't create a complex VBA (.xlsm) workbook and try it on 2007.
You'll have to convert it to 2007 (.xlsx) and then it will lose features. This is the point, .xlsm files are not recognized by older versions and .xlsm cannot be 100% converted to .xlsx or .xls.

I've just done a quick check. All my spreadsheets (even the one I just created to check this) are still .xlsx, none save as .xlsm.

That must be why they still work flawlessly.

Will report back on 2016 functionality after I give it a go this weekend.
*Insert profound or witty phrase here*

Offline Trompie67

Re: microsoft office
« Reply #19 on: May 18, 2018, 05:16:59 PM »
So I opened all the workbooks on  :angrywife: laptop running office 2016.

Worked on some of them, saved - still saving as .xlsx.

Moved them back to my desktop with Office 2010 & full functionality is still there, so all good :)
*Insert profound or witty phrase here*

Offline Dolby

Re: microsoft office
« Reply #20 on: May 19, 2018, 11:01:11 AM »
I actually second O365

Buying software takes me to the early 2000s:)

Offline santoshlv426

Re: microsoft office
« Reply #21 on: May 22, 2018, 08:55:20 AM »
@ Trompie,
When you save, go to Save As - Select from the drop down list on save type and .xlsm is the 2nd - .xlsx is default sometimes depending on your settings.
But you must select .xlsm.