From this week’s reading: when Outlook’s Autocomplete … won’t, when Excel’s autocalc … doesn’t, cleaning up imported data in Excel, and what to do with 250 Vcards.
Autocomplete in Outlook not working — For those of you not familiar with the term “autocomplete” in this context, this is the feature by which Outlook will attempt to “guess” which email address you’re typing in after you’ve gotten about 3-4 characters in (so, if you’ve emailed email@example.com before, Outlook will offer to automatically complete the address after you’ve typed “john”). It’s a controversial feature, particularly among lawyers (for example, click here and here and here), but if yours suddenly stops working and you like this feature, click the title link above for a tip on restoring it.
Mass Import of VCards into Outlook – A Painful Process — From “friend of this blog” Vivian Manning comes the tale of an IT challenge: taking a disk with 250 (yes, two hundred fifty) VCards and saving them into someone’s Outlook Contacts. “Painful” pretty much nails it. If you’ve got an easier solution to share with Vivian, she’s invited any and all to leave comments on the article linked above.
Why Excel formulas might not calculate as expected — If you’ve ever had an Excel formula that you’ve checked (and double-checked and triple-checked), but you know it’s still not calculating right, Susan Harkins at TechRepublic has one more thing you can check.
Clean up imported data in Excel — Got some data you’ve pulled into Excel from another source? Microsoft’s Excel blog has a tutorial on re-formatting that data into a more aesthetically pleasing and/or useful layout (including stringing together different columns like lastname + firstname into one column). Click the link above for not only an illustrated tutorial, but also a practice spreadsheet you can work with at your desk.