Excel

Circular Reference? Excel’s most popular (!#?%) error message explained

Millions of people using Excel don’t get why they see the “circular reference” error message right after they’ve entered a formula. The message means that your formula is trying to calculate its own cell–kind of like when a dog chases its own tail. Because so many of you (millions) searched on “circular reference” on Office.com, we thought we should very clearly explain how to remove or fix your formula.

Access

Q&A with Access developer Juan Soto

Working in an ice cream factory in Chicago led Juan Soto to found IT Impact, Inc.,  an Access development consulting firm. The ice cream factory’s large Enterprise Resource Planning system required that he spend hours manually calculating whether a final batch of ice cream really made the company money. He had to factor the waste for every step of the manufacturing process and soon realized that he could automate the…

Word

Tip: How to cut and paste without messing up formatting

Why does formatting sometimes get messed up when you cut and paste text? And what is that thing that appears at the end of the last sentence every time you paste-like a fly returning to honey. That thing–the Paste Options button–is your friend, a worker bee and not a fly whose only job is to follow your formatting instructions. Learning how it works keeps you from wasting time manually formatting…

Access

How to save your Access SharePoint password

Recently, someone posted a comment on IT Impact Inc.’s blog asking how to get SharePoint to remember his password when he logged in via Access.  He wanted to avoid having to log in every time. Ben Clothier, a Senior Access Developer at IT Impact, knew the answer. He wrote a detailed blog post (with plenty of screenshots) that we’d like to share with you.  ITImpact has been building custom databases with…