Long-time subscriber Ed Pilarczyk wrote recently with a question about a malware problem he had solved. A friend had given him a subsequent tip, and he wanted to check it out: Hey Terry, Thanks again for all the hard work you put into your great newsletter! A few months back my wife caught a piece [...]
Microsoft Excel – Protecting Formulas in Cells
Subscriber Don Enderud wrote to ask a question about Microsoft Excel. He wants to use one of the features of Excel that is very valuable when you create a spreadsheet for others to use. Terry, A friend is sending me a very large spreadsheet (approx. 40 tabs, each worksheet with many columns and rows) which [...]
Excel Problem Too Many Cell Formats Error
I ran into an interesting (which, under the circumstances means aggravating and frustrating) problem this week with an Excel 2007 spreadsheet. I ran into an apparent bug in Excel 2007 which results in a "Too Many Cell Formats". My spreadsheet was about 40 MB in size (yes, that’s Megabytes!), has 10 or 11 sheets in [...]
Using Office 2003 on a Windows 7 Computer
Subscriber Carolyn Waterson wrote recently to ask about using Office 2003 with a new computer: Hi Terry My husband got an external hard drive for Christmas to back up all his research onto. However … it managed to strip everything off his internal hard disk and corrupt it – resulting in a brand new computer!! [...]
Sharing an Excel Spreadsheet with Other Readers
Subscriber Linda Jordan wrote with an unusual request. She’s working with an Excel file, and needs other employees to be able to access the same information. Hi Terry, I’m a relatively new fan of you and your site. Thanks for sharing your expertise. I’ve used several tips already. I have two spreadsheets exactly the same, [...]
101 Secrets of an Excel Addict
I found an interesting — and inexpensive — ebook called 101 Secrets of an Excel Addict. Priced at only $14.97, it is packed full of interesting tips and tricks that most users don’t know. I would bet that almost every one of these tips can be found in some form or another on the Internet, [...]
and