I have a 13-sheet workbook, where the last sheet consolidates data from the first 12 sheets. The Consolidate function works correctly, but when I save and close the workbook, the next time I open it, the Consolidation ranges are blank. How do I save these ranges to keep from having to recreate them every time I open the spreadsheet? Thanks for your help.
Always save in Calc native format, that is, .ods.
If you need to share the spreadsheet with someone who can’t open ods files (new versions of MS Office claim compatibility) then you can click File - Save a copy and save that xlsx