Poll : Which version of Excel is used in your business

Post Reply

Which version of Excel is used in your business?

Older than Excel 2010
1
4%
Excel 2010 and have already moved to the Planning Analytics series.
3
12%
Excel 2010 and am on the TM1 series of releases.
8
31%
Excel 2013
4
15%
Excel 2016
10
38%
 
Total votes: 26

User avatar
Steve Rowe
Site Admin
Posts: 1783
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Poll : Which version of Excel is used in your business

Post by Steve Rowe » Tue Jan 09, 2018 11:05 am

It would appear that IBM are withdrawing support of Excel 2010 for both Perspectives and PAx in the Planning Analytics release as from 1st of March 2018.

I don't think this has been announced anywhere but it can seen as a footnote in the prerequisites section of the Software Product Compatibility Report / Detailed System Requirements.

Not sure how big a deal this, so thought it worth running a poll to get some idea of the impact.
We're a little concerned because we still encounter prospects on Excel 2010 and won't have a product for them soon.

Paul Segal
Community Contributor
Posts: 244
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Poll : Which version of Excel is used in your business

Post by Paul Segal » Tue Jan 09, 2018 11:12 am

It's not a single answer question for us - Citrix is running 2010 and local installs are running 2013 (I know..) I'm aiming to roll out PA this year and make it all local, but we're still testing, so March might be a little tight. I would ideally expect a longer notice period from IBM.
Paul

User avatar
gtonkin
MVP
Posts: 605
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Poll : Which version of Excel is used in your business

Post by gtonkin » Tue Jan 09, 2018 11:37 am

Also not a straight forward answer as many of my clients have a blend of either 2010/2013 or 2013/2016 - there are some 2007 still floating around. At this stage, only TM1 series out there so not too concerned, yet.

User avatar
Alan Kirk
Site Admin
Posts: 5806
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: Poll : Which version of Excel is used in your business

Post by Alan Kirk » Tue Jan 09, 2018 8:20 pm

I suppose it had to happen eventually since 2010 is now 8 years in the past, though it's still arguably the most stable and predictable version out there. 2013 AND ITS ALL CAPS, ALL YELLING TABS was gone before anyone really knew that it was here; I never did use it operationally and I doubt that much end user development was done on it in the wider scheme of things. The biggest problem with 2016 (from an Iboglix support point of view) is the way it forked between the boxed version, and the Office 365 version since the latter is constantly being updated with new features and can therefore change unpredictably. And we've already seen how that can turn out. (Though to the credit of all concerned, the turnaround on that fix was relatively quick. I think people may feel differently if they were using the 365 incarnation of Excel 16 operationally, though; fast isn't fast enough.) And of course 2019 will be out (in pre-release) some time in the next 6 months. I wonder what features Microsloth will pull from that one? (The removal of offline help and the Recent Folders features being the two that have gotten up users' noses more than most.) I don't hate 2016, but I don't like it either. The main reason that I use it is that the language packs work really well in Word, which helps if I'm writing in Italian. Other than that, I prefer 2010.

Which is fortunate, because my workplace dumped the MS Office oriented workplace in favour of Google... uh, what do they call it this week? Oh yeah, GSuite. The G Suite apps are for the most part a pathetic joke compared to the raw performance of Office, but they're generally good enough for those who don't need to create complex documents or do intensive analysis work. This means that we have a shedload of unused licences... but they're all for Office 2010. And since this was principally a cost cutting exercise, I do not see upgrades in the foreseeable future.

For mine... I have no intention of going PA2 at any time in the foreseeable future either. I addressed this on my YouTube channel last week. I can get the server / perspectives / client / architect to work. I cannot get Web to work yet (yay Websphere Liberty) and it doesn't help that I'm not seeing what the manual says I should be seeing. The installation manual that is over 372 pages long. As opposed to the SQL Server installation manual, which is a dialog. (Yes, there are documents available but unlike with PA2, you don't need to read them. because the install process is so smooth and easy.) And after the last nightmarish experience I haven't even begun making a new attempt with PAW and PAX yet. As I said, they'll probably work if I throw enough time at them "not that I should have to, but that's a separate conversation". Sort of. I was discussing the issue with someone at the last Cubewise conference. I can't remember which one of us said it but both of us were thinking it; the benefits of PA2 just aren't worth the effort in getting the accursed thing working. For me, it's 10.2.2 and 2010 for the foreseeable future.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
jim wood
Site Admin
Posts: 3577
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Poll : Which version of Excel is used in your business

Post by jim wood » Tue Jan 09, 2018 8:45 pm

Just to throw a spanner in the works I use Office 2011 on my mac :oops:
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Alan Kirk
Site Admin
Posts: 5806
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: Poll : Which version of Excel is used in your business

Post by Alan Kirk » Tue Jan 09, 2018 8:48 pm

jim wood wrote:
Tue Jan 09, 2018 8:45 pm
Just to through a spanner in the works I use Office 2011 on my mac :oops:
Yes, but that's because the gods hate you and have decided to give you an early taste of Hell.

(So how well does Perspectives work on that? ;) )
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
tomok
MVP
Posts: 2464
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Poll : Which version of Excel is used in your business

Post by tomok » Wed Jan 10, 2018 11:57 am

Alan Kirk wrote:
Tue Jan 09, 2018 8:20 pm
I addressed this on my YouTube channel last week.
I'd love to watch your shows/webisodes/whatever they're called. Not just to learn more about this topic but also to see if you really do look just like Mark Harmon.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

User avatar
jim wood
Site Admin
Posts: 3577
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Poll : Which version of Excel is used in your business

Post by jim wood » Wed Jan 10, 2018 1:00 pm

tomok wrote:
Wed Jan 10, 2018 11:57 am
Alan Kirk wrote:
Tue Jan 09, 2018 8:20 pm
I addressed this on my YouTube channel last week.
I'd love to watch your shows/webisodes/whatever they're called. Not just to learn more about this topic but also to see if you really do look just like Mark Harmon.
Right hair colour
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Alan Kirk
Site Admin
Posts: 5806
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: Poll : Which version of Excel is used in your business

Post by Alan Kirk » Thu Jan 11, 2018 11:20 am

tomok wrote:
Wed Jan 10, 2018 11:57 am
Alan Kirk wrote:
Tue Jan 09, 2018 8:20 pm
I addressed this on my YouTube channel last week.
I'd love to watch your shows/webisodes/whatever they're called. Not just to learn more about this topic but also to see if you really do look just like Mark Harmon.
FaceToCamera2.jpg
FaceToCamera2.jpg (96.95 KiB) Viewed 794 times
I did briefly consider doing a data management riff on Roberto Tartaglione's Grammatica Caffè series, but I don't have that kind of space and the lighting is a pain in the backside to do. So you'll have to make do with Max.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

Post Reply