The frustration is real. We’ve all watched the loading bar inch towards its inevitable conclusion at a snail’s pace. If you’ve ever stressed about whether you’ll miss a deadline because your .xlsx spreadsheet file is going haywire, you’re not the only one.
Small businesses and digital marketers alike often use spreadsheets for a simple way to track content (text or numbers) that might be calculated, sorted, or listed. This includes tracking project management, budgeting, cash flow, invoicing, scheduling content calendars, and uploading contact data to your CASL compliant email lists. For many solopreneurs and freelancers, using a spreadsheet is a free way to keep information all in one place without a complex system, and it’s often their only lifeline to that critical data.
Sheets, Google’s spreadsheet tool in GSuite, is a cloud service that can be accessed from anywhere, from any kind of computer. It can save to .pdf, .xlsx, .csv and even .html, making it a handy tool to work with for a savvy digital professional on the go, but there’s one drawback for those big files on Google Sheets: lag. Is the tool working for you, or are you working for it?
Your deadline is approaching, but your Google Sheet is protesting in one of the following ways:
So why the lag?
There are several reasons why Google Sheets might be giving you grief, and they all come down to have you reached (or even exceeded) the limits? Individual cell-size is limited to 50,000 characters (roughly 500 average-length sentences). Per workbook, you are allowed:
There are several steps you can take to speed up Google Sheets.
It’s advantageous to keep one copy of the formula at the top of your data columns for record-keeping purposes and future use.
Still not working? Perhaps it’s time to move your data to a database or CRM. In the meantime, we hope you’ve found this information valuable, and good luck!
If you would like to set up GSuite for your business, come talk to us and we’ll make sure it’s connected correctly. Read more about our GSuite services here and contact us for a custom quote. Simple account setups start at only $100!