Old version of Excel.

%3CLINGO-SUB%20id%3D%22lingo-sub-3347471%22%20slang%3D%22en-US%22%3EOld%20version%20of%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3347471%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20old%20version%20of%20my%20Monthly%20Billing%20Reports.%20It%20is%20ods.I%20want%20to%20use%20it%20as%20my%20Monthly%20report%20spreadsheet.%20A%20lot%20of%20the%20things%20that%20worked%20no%20longer%20work.%20I%20need%20to%20add%20more%20rows%20and%20columns%20and%20insert%20a%20section%20of%20the%20reports%20before%20a%20column%20of%20each%20month.%20I%20know%20nothing%20about%20excel%20and%20am%20at%20a%20loss%20of%20what%20I%20need%20to%20do%20so%20I%20can%20catch%20up%20on%20my%20reports.%20The%20update%20sheet%20doesn't%20update%20so%20I%20can%20have%20a%20copy%20for%20my%20records.%20the%20update%20button%20use%20to%20have%20a%20dialog%20box%20and%20you%20would%20put%20the%20date%20of%20the%20report%20you%20wanted%20to%20update.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3347471%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3349048%22%20slang%3D%22en-US%22%3ERe%3A%20Old%20version%20of%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3349048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1385297%22%20target%3D%22_blank%22%3E%40Patricia__1945%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EThe%20%22.ods%22%20are%20files%20from%20OpenOffice%2C%20not%20from%20Excel.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EOpenOffice%20is%20based%20on%20the%20possibilities%20that%20Excel%20offers%2C%20but%20with%20limited%20possibilities%20compared%20to%20Excel.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EIt%20was%20preferred%20for%20the%20simple%20reason%20that%20it%20was%20free%2C%20but%20now%20Microsoft%20has%20%22Excel%20for%20Web%22%20for%20it.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20a%20link%20with%20options%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-excel-to-open-or-save-a-worksheet-in-the-opendocument-spreadsheet-ods-format-c7114baa-f08a-49eb-aefd-f5d61ed347cd%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EUse%20Excel%20to%20open%20or%20save%20a%20worksheet%20in%20the%20OpenDocument%20Spreadsheet%20(.ods)%20format.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FA%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fdifferences-between-the-opendocument-spreadsheet-ods-format-and-the-excel-for-windows-xlsx-format-3db958c8-e0ac-49a5-9965-2c2f8afbd960%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EDifferences%20between%20the%20OpenDocument%20Spreadsheet%20(.ods)%20format%20and%20the%20Excel%20for%20Windows%20(.xlsx)%20format%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FA%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EConsider%20that%20some%20formulas%20may%20also%20have%20to%20be%20converted%20manually%20and%20added%20again%2C%20which%20is%20a%20lot%20of%20manual%20work%20that%20probably%20nobody%20wants%20to%20vouch%20for.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EOtherwise%20you%20would%20have%20to%20submit%20this%20as%20a%20commission%20if%20there%20are%20many%20and%2For%20large%20files.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EAnyway%2C%20look%20at%20the%20links%20with%20the%20information%20in%20one%20by%20one%20and%20see%20your%20options.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20information%2Flinks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Visitor

I have an old version of my Monthly Billing Reports. It is ods.I want to use it as my Monthly report spreadsheet. A lot of the things that worked no longer work. I need to add more rows and columns and insert a section of the reports before a column of each month. I know nothing about excel and am at a loss of what I need to do so I can catch up on my reports. The update sheet doesn't update so I can have a copy for my records. the update button use to have a dialog box and you would put the date of the report you wanted to update.

1 Reply

@Patricia__1945 

The ".ods" are files from OpenOffice, not from Excel.
OpenOffice is based on the possibilities that Excel offers, but with limited possibilities compared to Excel. It was preferred for the simple reason that it was free, but now Microsoft has "Excel for Web" for it.
 
Here is a link with options:
 
Consider that some formulas may also have to be converted manually and added again, which is a lot of manual work that probably nobody wants to vouch for.
Otherwise you would have to submit this as a commission if there are many and/or large files.
 
Anyway, look at the links with the information in one by one and see your options.
 

Hope I was able to help you with this information/links.

 

NikolinoDE

I know I don't know anything (Socrates)