google sheets
I keep getting the message on my Google spreadsheet that I'm using the old spreadsheet. There is an option to create the new Google sheet, but no option to upgrade the existing.
Please check this image.
Even the sheets I create now is the new Google sheet by default. Please let me know whether there is an option to upgrade the existing one.
The bottom of the window will list your tabs on the left and have a couple options to the left of those. Clicking the + will add a new sheet.
With the latest update of Google Drive size limits (Apr 2019), it says the following:
Spreadsheets: Up to 5 million cells for spreadsheets that are created in or converted to Google Sheets.
Simply ᴄᴏʟᴜᴍɴs × ʀᴏᴡs can't exceed 5 000 000 cells.
Additionally, the maximum number of columns can't exceed 18 278. According to Rubén
With the starting 26 columns (A-Z), the maximum height is 192 307, which is 4 999 982 cells
With the starting 1000 rows, a maximum of 500 000 columns is expected, but due to the second bound only 18 278 can be used.
Best Answer
If you download the old Doc as an XLSX, then upload and convert to Google doc version, it upgrades the doc. I haven't found anything it doesn't keep yet. It even kept my named ranges.
[EDIT] I did have to "tickle" some functions by removing, then re-adding the = sign in front. Or double-clicking the cell, then just hitting enter. Maybe I just wasn't patient, but the majority of my complex spreadsheet was still functioning after the procedure above.