"Microsoft Excel 2019 Inside Out", error at start of Chapter 17?

rd18010

New Member
Joined
Jan 23, 2012
Messages
17
Office Version
365, 2019
Platform
Windows
When I got to work this morning, I was doubting what I posted last night, so found that one way to find the Microsoft Office executable files directory is the VBA code "?application.path" which I ran, and found the EXCEL.EXE file dated 6-6-19, the date Office was installed, and whole Properties-Details tab has the Product Version of "16.0.10827.20150". To confirm yet again, when Excel is running, Task Manager takes me to the same file.

Since my PC is also running Windows 10 Version 1803 ("April 2018 Update"), it seems that both my OS and MSO are stuck in 2018.
So it seems neglect, rather than over-aggressive GPOs are the theme.

My next step this evening is to order a copy of Microsoft Excel 2019 Pivot Table Data Crunching.
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

rd18010

New Member
Joined
Jan 23, 2012
Messages
17
Office Version
365, 2019
Platform
Windows
Looking back at a link in a post of mine from a few days ago, Is Excel 2019 just Excel 2016 with a new name?, I see that they bought Office 2019 for testing, and reported:

"Excel 2019 with latest updates on October 5th, 2019 shows: 16.0.10827.20118"

Which is the same as my Excel reports in the File, Account, About Excel when the button is clicked.

After correcting their typo (which I will alert them to after I post this), they report the visible:

Via File > Account, Office 2019, shows:
Version 1809 (Build 10827.20138 Click-to-Run)


Which is lower than my '20150, which would make mine seem more recent, which is puzzling since the date-time stamp on the EXCEL.EXE is 6-6-19, earlier than their October 2019. (Yet as I noted in the last post, its Properties-Details tab has the File/Product version as 16.0.10827.20150.)

So maybe my Excel is actually up to date, afterall, but how to really verify all this?
 

rd18010

New Member
Joined
Jan 23, 2012
Messages
17
Office Version
365, 2019
Platform
Windows
Once again, I failled to read down to the comments on ASAP's page from the last post, and saw that the biggest typo must be that he must mean October 5th, 2018 not 2019, as the comments are from Nov 2018.

And he wouldn't be buying MSO 2019 in late 2019 to test out, but in late 2018.

And that 400 page Microsoft PDF has Version 1809 (Build 10827.20138) being for September 27, 2018.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,364
Office Version
365, 2010
Platform
Windows, Mobile
Below is in reference to the Office 365 version shown in your profile.

Version 1809 (Build 10827.20138 Click-to-Run)
Which is lower than my '20150, which would make mine seem more recent, which is puzzling
Office build number partly depends on whether it is the monthly, Semi Annual or Semi annual (targeted) channel so you could have multiple build numbers. Just for reference I am currently on Version 2002 (Build 12527.20194 Click-To-Run).
So maybe my Excel is actually up to date, afterall, but how to really verify all this?
Manually try an update?
Link to List of current versions Office 365

And
Link to versions for 2016/2019
 
Last edited:

rd18010

New Member
Joined
Jan 23, 2012
Messages
17
Office Version
365, 2019
Platform
Windows
After realizing that ASAP's page had many typos, and alerting Bastien to correct them, I realized that I really do have the very old MSO 2019 from when it first became available to our IT department. The build numbers don't match what I see in the Microsoft link and downloadable PDF. My attempting to manually update doesn't do anything.

As Bastien's page, and many others that point to it, have found, is that it is very difficult to detect what version of Excel one is really running. I have read many ideas about what VBA code to run and what registry keys to look at, but nothing seems to let me know that I really have. So I'm going to assume at the worst case, the IT department would be able to get updates every six months, if they were to want to. As an end user I don't have any control over that.

I've stopped looking into this, for now, and am finally working my way through Bill's excellent "Microsoft Excel 2019 Pivot Table Data Crunching" book, and realizing how much more power we have at our fingertips. It may also give me some ideas how to approach a different department with what our end users are being denied by having a too old version of Excel 2019.
 

rd18010

New Member
Joined
Jan 23, 2012
Messages
17
Office Version
365, 2019
Platform
Windows
As stated in my last post, I am working my way through Bill's excellent "Microsoft Excel 2019 Pivot Table Data Crunching" book, and ran into the first snag.

In Chapter 4 "Grouping, sorting, and filtering pivot data", on page 116, in the "Creating hierarchies" section, under Figure 4-59, the book has five steps described starting with:

Follow these steps to add a hiearchy below Region:
  1. Click the Manage icon in the Power Pivot tab of the ribbon.
Since I don't have the Power Pivot ribbon, my question is if there is an alternative way to get do what is being asked?
 

Watch MrExcel Video

Forum statistics

Threads
1,095,171
Messages
5,442,801
Members
405,198
Latest member
Florence Thomas

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top