Yes, Excel 2010 certainly can work offline in the way you describe. Even Excel 2016/365 can do what you describe. BUT, this is not the best way to work.
Does Office 365 always have to be online?
There’s an understandable misconception that the new Office 365 licence system (which counts Office sign-in not installs) means Office always has to be online … NOT so. Once signed-in to Office, the software will be activated with full functionality for 30 days. After 30 days offline, Office software will stop working fully.
One inquiry we ran across in our research was “What happens if I go offline for 30 days?”.
After 30 days offline, Office software will stop working fully. It will drop to a Read Only mode with no editing allowed. To get Office back to full working order, you’ll need to reconnect to the Internet and sign-in to Office again. Once that’s done you can go offline again for another 30 days.
Can microsoft excel open ods?
ODS files are the default file format for worksheets which are generated and saved by using the Apache Open Office suite. The .ods file type are compatible with Apache Open Office only and cannot be opened with other spreadsheet programs, including Microsoft Excel.
Which Excel features are supported in the OpenDocument spreadsheet (ODS) format?
The table below shows which Excel features are fully, partially, or not supported in the Open. Document Spreadsheet (.ods) format. Supported Both Excel and the Open. Document Spreadsheet format support this feature. Content, formatting, and functionality won’t be lost.
How do I open an OpenDocument file in Excel?
2 To only see files saved in the Open. Document format, in the file type list (next to the File name box), click Open. Document Spreadsheet (*.ods). 3 Find the file you want to open, and then click Open.
Simply select the name of desired file that you wish to select. In case you wish to see only the ODS files, simply click Open Document Spreadsheet (*.ods) in the file type list. Click the desired file and then open it:-.
What happens when I save a file in ODS format?
When you save the file in .ods format and open it again in Excel, some Data Labels are not supported. When you save the file in .ods format and open it again in Excel, some Trendlines are not supported. When you save the file in .ods format and open it again in Excel, some Error Bars are not supported.