A few weeks back I was asked to create a rule in Excel that would recalculate a cell’s value ONLY on Monday!  And store that calculation. What?  Hmm..  Then I thought, wait a minute, I should be able to do this in the cells directly. At first I tried to do this all in one… Read More

This through me for a look.  Seems that if you have a skype plugin installed, you cannot cut and paste formulas in Excel.  Pretty random till you think about it. The skype plugin is pretty aggressive trying to capture what it thinks are phone numbers and its totally possible the its intercepting the paste function… Read More

As a developer and analyst, I heavily rely on the powerful features and flexibility that Microsoft Excel provides for various tasks. This was especially true when I was supporting enterprise level accounting systems. I would often be working with two or more workbooks at a time, and loved having the ability to view two worksheets… Read More