Thursday, September 27, 2012

Excel Tip of the Week 9/27

Sorry I missed last week's tip -- it's been a bit of a crazy week. Well, crazy month.
This week's tip is more of a guideline... if your computer is kind of old and doesn't have extra memory just hanging around, try and close as many applications and windows as possible before opening a big spreadsheet. From what I've heard, bigger than 10,000 rows is big. The one I was trying to open was 400,000 rows (hint: Excel really doesn't like spreadsheets that big), and I drew that Excel logo sticky note art while it was opening. The main guideline is actually to try and avoid really big spreadsheets; they're not a lot of fun and sometimes they send you nice error messages.

No comments:

Post a Comment