Any secret with regards to "what to do" when Google Docs spreadsheet gets "too full"?

Hello. I have a shared Google spreadsheet. It is hanging up and no longer allows data to be input. It is very large.

Is there any secret with regards to "what to do" when Google Docs spreadsheet gets "too full"?

I'm pretty sure that is my problem.

I get error messages if I try to download it or create a copy of it. See screenshots:

1

2
Should I just start deleting data?
LVL 1
greghollAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bas2754Commented:
From the following: https://support.google.com/drive/answer/37603?hl=en

Click on the link that says "More information about spreadsheet size limts"

A couple items of interest are quoted below:

"If you're close to exceeding Google spreadsheets size limits, you'll see a message at the top of your spreadsheet that indicates what limit you're about to reach.

    Number of cells: 400,000 total cells across all sheets
    Number of columns: 256 columns per sheet
    Number of formulas: 40,000 cells containing formulas across all sheets
    Number of tabs: 200 sheets per workbook
    GoogleFinance formulas: 1,000 GoogleFinance formulas
    ImportRange formulas: 50 cross-workbook reference formulas
    ImportData, ImportHtml, ImportFeed, or ImportXml formulas: 50 functions for external data.

Spreadsheets also have overall storage limits. Some spreadsheets may reach these before hitting the 400,000 cell limit, particularly when individual cells have large amounts of text. In such cases, the spreadsheet will go into read-only mode to prevent data loss."

"Tips & Tricks

    Try breaking up a large spreadsheet into multiple smaller spreadsheets.
    Minimize the number of complex formulas. See the list above for examples of functions that increase complexity.
    After getting data points through any complex formula, try to copy-and-paste them as "values only."
        Select the values and copy them.
        Go to the Edit menu.
        Point your mouse to "Paste special."
        Select "Paste values only."
    Minimize the number of cells that depend on:
        A large number of other cells.
        Cells with complex formulas.
        Cells that are changed frequently."

"All spreadsheet limits mentioned above have been removed in the new version of Google Sheets. The new version of Google Sheets should support 2 million cells of data, though please note that extremely large spreadsheets may have slower performance. Learn more about switching to the new version of Google Sheets."

If you follow the link about switching to the new version of Google Sheets it takes you here: https://support.google.com/docs/answer/3544847 and says:

"Moving spreadsheets to the new Google Sheets

Starting in March 2014, the new version of Google Sheets will become the default for all users when creating a new spreadsheet. Older spreadsheets will remain in the old version of Sheets for now*, but you can manually move spreadsheet contents into the new version of Sheets to take advantage of new functionality, following any of these steps:

    Copy and paste content from a spreadsheet created in the old version to a spreadsheet created in the new version.
    In a spreadsheet created in the old version, click the down arrow next to a sheet tab and click Copy to…, and copy the sheet (and its contents) to a spreadsheet created in the new version.
    Export the contents from the old version and import them into a spreadsheet created in the new version.

*Spreadsheets created in the old version of Sheets will eventually be converted to the new Sheets, which won’t require any action on your part. More details coming soon."

I would try moving to the new version first if possible.  If not, then you can try the suggestions in the "Tips and Tricks" section.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
greghollAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Spreadsheets

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.