What is the most current version of Office?
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
What is the most current version of Office?
What is the most current version of Office? How long has it been since release? What is covered versus the previous version(?)?
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: What is the most current version of Office?
There are two branches:
The most recent "perpetual license" (one-time buy) version is Office 2019. See What's New in Office 2019. It does get bug fixes and security updates, but no feature updates.
The subscription version (pay a monthly or yearly fee) is now called Microsoft 365. Although its core is the same as Office 2019, it gets new features regularly in addition to bug fixes and security updates. See What's new in Microsoft 365.
The most recent "perpetual license" (one-time buy) version is Office 2019. See What's New in Office 2019. It does get bug fixes and security updates, but no feature updates.
The subscription version (pay a monthly or yearly fee) is now called Microsoft 365. Although its core is the same as Office 2019, it gets new features regularly in addition to bug fixes and security updates. See What's new in Microsoft 365.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
Re: What is the most current version of Office?
Would 2019 be able to download import a MS Edge web file?
ETA Would my .xls files be ok? Or would they all have to be converted?
ETA Would my .xls files be ok? Or would they all have to be converted?
Last edited by bknight on 02 Jan 2021, 15:39, edited 2 times in total.
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: What is the most current version of Office?
Downloading is not a feature of Office, but a browser function.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: What is the most current version of Office?
As far as I know, Excel 2019 still uses Internet Explorer for web queries, even if you use another browser as default browser.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
Re: What is the most current version of Office?
Ok, that doesn't do any better.
-
- GoldLounger
- Posts: 2599
- Joined: 24 Jan 2010, 15:26
- Location: Olympia, WA
Re: What is the most current version of Office?
What do you mean by "MS Edge web file"?
The web pages are based on the HTML formats, but if you are downloading a excel file that is being stored at a web sit, then it is just a excel file.
What issues are you having with these files?
The web pages are based on the HTML formats, but if you are downloading a excel file that is being stored at a web sit, then it is just a excel file.
What issues are you having with these files?
I am so far behind, I think I am First
Genealogy....confusing the dead and annoying the living
Genealogy....confusing the dead and annoying the living
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
Re: What is the most current version of Office?
Importing from a web format. My Excel default web is IE(s) and none will properly open a current web address for any import.
ETA As a matter of fact the little import progress bar loads about half way and then stalls. This forces me to shut it down manually before I am able to do anything within Excel. Further my goal was to code this loading and have it done within a function. If you see anyway that I might solve my dilemma, I would appreciate the help. the address to download from is
https://markets.cboe.com/data/
ETA As a matter of fact the little import progress bar loads about half way and then stalls. This forces me to shut it down manually before I am able to do anything within Excel. Further my goal was to code this loading and have it done within a function. If you see anyway that I might solve my dilemma, I would appreciate the help. the address to download from is
https://markets.cboe.com/data/
-
- GoldLounger
- Posts: 2599
- Joined: 24 Jan 2010, 15:26
- Location: Olympia, WA
Re: What is the most current version of Office?
So, there are four groups and within each are three options.
Then there are several options within each of the 12 above.
What and which file type are you downloading?
Then there are several options within each of the 12 above.
What and which file type are you downloading?
I am so far behind, I think I am First
Genealogy....confusing the dead and annoying the living
Genealogy....confusing the dead and annoying the living
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
Re: What is the most current version of Office?
Looking for only VIX,
From there I need only 4 numbers
Last, Open, High, Low.
I'm not downloading any file, just attempting to import, using code, those four numbers into a spreadsheet at todays date which has been already entered into the spreadsheet.
My Excel has only IE(s) as default web import and manually attempting that only loads about 50% and freezes. I then MUST exit Excel and start over.
The only possible solution is to got to HTML and find the numbers required and attempt to code in finding those numbers and placing them into the spreadsheet at the appropriate cells. I do this everyday and that is why I have it running code. There are other data that go into the spreadsheet, but that code still works. CBOE changed the VIX data presentation mid Dec relegating that piece of code void.
From there I need only 4 numbers
Last, Open, High, Low.
I'm not downloading any file, just attempting to import, using code, those four numbers into a spreadsheet at todays date which has been already entered into the spreadsheet.
My Excel has only IE(s) as default web import and manually attempting that only loads about 50% and freezes. I then MUST exit Excel and start over.
The only possible solution is to got to HTML and find the numbers required and attempt to code in finding those numbers and placing them into the spreadsheet at the appropriate cells. I do this everyday and that is why I have it running code. There are other data that go into the spreadsheet, but that code still works. CBOE changed the VIX data presentation mid Dec relegating that piece of code void.
-
- Microsoft MVP
- Posts: 1318
- Joined: 24 May 2013, 15:33
- Location: Warminster, PA
Re: What is the most current version of Office?
Microsoft 365 (the subscription version, which gets update features, unlike the one-time-purchase Office 2019) can do this without web apps or other add-ins. The key to the feature is a new data type, Stock, which can pull data about listed stocks using internal code. Read https://support.microsoft.com/en-us/off ... a89e210877 and other articles such as https://www.mrexcel.com/excel-tips/stoc ... -in-excel/.
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 12612
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: What is the most current version of Office?
I have the latest version of Excel
but I don't see the Data Types group on the Data ribbon. Do I have to enable it in some way?
You do not have the required permissions to view the files attached to this post.
StuartR
-
- Administrator
- Posts: 12612
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: What is the most current version of Office?
Replying to my own observation. I had been logged out of my Microsoft account when I last ran ccleaner, and had to log back in again to enable this.
StuartR
-
- Microsoft MVP
- Posts: 1318
- Joined: 24 May 2013, 15:33
- Location: Warminster, PA
Re: What is the most current version of Office?
Ah, that would do it.
The new data types Stock and Geography were released in June 2020, with Version 2005 (Build 12827.20268).
The new data types Stock and Geography were released in June 2020, with Version 2005 (Build 12827.20268).
-
- BronzeLounger
- Posts: 1391
- Joined: 08 Jul 2016, 18:53
Re: What is the most current version of Office?
Don't have 365, as I'm not paying MS monthly to use their product.
ETA Nor am I going to pay for an upgrade not knowing if the data import feature uses Edge and whether my 4000+ .xls files would work in a newer version(backwardation IIRC)
ETA Nor am I going to pay for an upgrade not knowing if the data import feature uses Edge and whether my 4000+ .xls files would work in a newer version(backwardation IIRC)