How to fix: File in Use – Personal.xlsb is locked for editing


I recently added some macros into my PERSONAL.XLSB file for Excel and started getting these annoying pop-ups saying that it’s locked for editing. This file loads in the background every time you open a copy of Excel. The point of it is to give you a place to save commonly used macros that will then be loaded and available to you in whatever workbooks you open. The problem with this is that if you open multiple copies of Excel, they all ask the operating system for write permissions in case you want to update the file.

This article explains how to fix this issue depending on whether you want to keep the file or get rid of it.

Read the rest of this entry »

Word 2007 Quick Tip – How to show invisible table borders/gridlines


Every time I reinstall Word, I always forget where in the settings I can turn on the display of table gridlines. I find it really frustrating that it’s not on by default since, when you can’t see the invisible borders of cells, you can’t tell how many cells make up a section of white space. So, for my future reference and your benefit (hopefully) :), here’s how you turn on gridlines (table borders) in Office 2007.

Read the rest of this entry »

Latest Posts



Post Calendar

October 2014
M T W T F S S
« Sep    
 12345
6789101112
13141516171819
20212223242526
2728293031