When newer versions of Office programs come out, there is new functionality which is not available in the older versions. Specifically, if you are working with someone who is still using Office 2003 then you will have issues because the file format changed with Office 2007 which is the release that followed 2003. In later versions, new features keep being added so it becomes necessary to save the workbook in a 2003 friendly way. This is called Compatibility Mode.
You can set your workbooks to be saved in this mode all the time, however be aware that you will lose functionality. Alternatively, you can save workbooks individually if you know you need to send them to someone with the older version. Read our tips for saving documents in compatibility mode here.
Compatibility Mode
Figure 54-Look for Compatability Mode at the top of the screen
When you have a file that has been saved in compatibility mode it will tell you at the top of the screen.
New Excel functions. You’ll find several new functions in the math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function categories. Also new are a few Web service functions for referencing existing Representational. There have been 29 different versions of Excel, stretching from 1985 to the present day. These days most users today will have Excel 2016, 2019 or 365. Each version of Excel has been significantly different to the last, and the Mac and Windows versions are still very different today. Nov 30, 2018 Microsoft Excel 2019 training video on the first look at the new Excel 2019 program, an overview of the Excel 2019 application interface. (Excel 365 Skills i.
To save in Compatibility Mode
Figure 55- Change the Save as type to save in Compatibility Mode
- Click File
- Click Save As
- Navigate to the folder where you wish to save the workbook
- Type a name for your file
- Change the Save as type to Excel 97-2003 workbook
- Click Save
Save all files in Compatibility Mode
Figure 56- Set Compatibility Mode as the default setting
- Click File
- Click Options
- Click on Save
- Change the Save files in this format box to Excel 97-2003
- Click OK
Whenever you save a workbook in the future, it will be saved in Compatibility Mode once you change this setting.
Convert an Excel 97-2003 file to a later version
Figure 57- Convert your older files to get the most up to date functionality
If your file is in Compatibility Mode you will see the Convert button in the Backstage View.
- Click File
- Click Convert
Note the explanatory text that mentions that the file will be converted and that this may result in layout changes.
You might also want to check out other Excel blogs such as “How to assign shortcuts in Excel 2013”, “Remarkable features of the quick access toolbar in Excel 2013” or “Best Excel 2013 tricks: Naming a Cell” and “How to add value to workbooks in Excel“.
Microsoft officials recently announced on Tuesday, during its Ignite IT Pro conference in Orlando, that the company is going to launch in early 2018 the new version of Microsoft Excel, which is coming smarter due to a new algorithm and better worldwide connection. According to the company’s blog, it will also offer a non-subscription version for the public that prefers to try the program’s new advances before buying the complete version.
List Of Excel Versions
Microsoft Excel will soon come more connected not only to the outside world but also with the user. The program will learn certain aspects of the user’s work to bring from the internet everything that the algorithm considers would be beneficial for it, as Jared Spataro, Microsoft’s general manager for Office, and Rob Howard, the company’s director of Office 365 ecosystem marketing, said at the conference.
It was also announced that the company would offer a public and complete packet with Office apps like Word, Excel, PowerPoint, Outlook, and server apps like Exchange, SharePoint, and Skype for Business. Additionally, there are some rumors that Excel will also be available for the Apple Mac, but anything has been confirmed by Microsoft officials yet.
Both the Office 2019 complete and public preview version will come with totally new impressive analysis and visual-animation features, like improved inking (pressure sensitivity, tilt effects, ink replay), formulas and charts for Excel, and the PowerPoint Morph and Zoom.
Download New Excel Version
The American multinational technology company also said that people would be able to manage this version very easily because the developers added it new usability, voice and security features.
“We’re pleased to introduce new data types,” said Jared Spataro on the conference. “That doesn’t sound all that interesting and we had this interesting discussion about what we’d name these things, but at the end of the day we realized that if you’re really an Excel wonk, the thing that you’re going to get is that there’s new data types.”
Microsoft Excel, smarter than ever
This new Excel version will be able to differentiate two particular companies within one same list, according to Microsoft officials, due to its algorithm. The program will extract information about one specific company from Microsoft’s Bing API – including stock data and market cap.
New Excel Version Download
Excel will also differentiate if the user creates a list of people, enterprises or cities, to then provide it with information that’s usually obtained from tedious analysis, like population data and others.
Excel New Version Download
The “Insight Service” will remark interesting information for the user to make it visible as “one of the most important.” However, this is something already found in Google Sheets. “It is meant to take any list of data and then start to generate insights,” which later “will look at combinations, charts, pivot tables” to recognize the most impressive by “looking at outliers, looking at trends in the data, looking at things that represent changes.”
“Cloud-powered innovation is a major theme at Ignite this week. But we recognize that moving to the cloud is a journey with many considerations along the way,” according to Microsoft’s general manager for Office. “Office 2019 will be a valuable upgrade for customers who feel that they need to keep some or all of their apps and servers on-premises, and we look forward to sharing more details about the release in the coming months.”
Excel New Version Share Workbook
Source: TechCrunch