Welcome To Diliptechnoblog.com- We Give You Latest Reviews on Technology, Gadgets, Mobile, Laptop, computer software and Hardware reviews, Cars, Bikes, Games, SEO, Social Media, Tips and Tricks, Hacking and Security, Earn Money Online, Latest Innovations and many more.
Saturday, January 14, 2017
GOOGLE DRIVE FILE SIZE LIMITS
The question comes up regularly about the file size limits of Google Drive apps. At what point will Drive limit you from continuing to type in Documents? What about row or cell limits in Spreadsheets? Does Presentations have a number of slides limit? All those answers and more in the table below.
Have specific questions about limits/restrictions in Drive? Tweet me or comment below!
GOOGLE DRIVE FILE LIMITS
File Size Limits
Other (app specific) restrictions
up to 50 MB each
Up to 1,024,000 characters, regardless of the number of pages or font size
no specific size limit
up to 2 million cells
restriction includes questions and responses in forms
Also has complexity restrictions - if sheets get too complex, they will time out (extensive formula use)
up to 100 MB each
no other restrictions
no restrictions at this time
up to 5 TB per file uploaded
for files uploaded to drive but not converted to Google format
Google shares a few formulas that specifically contribute to the complexity of your sheet, they are the following:
VLOOKUP, QUERY, SUMIF, and similar formulas that take a large range of cells as input.
Volatile formulas (for example, NOW, RAND, OFFSET, INDIRECT) are recalculated every time the spreadsheet is modified. If there are a large number of formulas that depend on cells with volatile formulas, they will be recalculated on each edit, which may slow down a spreadsheet.
Import-based formulas (e.g., IMPORTRANGE) are recalculated periodically and increase complexity.
Also, it is recommended that you compress images prior to importing them to your document or presentation to reduce file sizes.