Going, going, ...

Two weeks ago today I mentioned the release of ExcelTips: The Macros, 8th Edition. At just shy of 1,000 pages, this new edition is the definitive resource on "all things macros" when it comes to Excel.

When I announced the new edition, I also announced that it would be available at 30% off the regular price for a limited time. That time has come; the discounted price will be going away by the end of the day Monday, July 25.

If you haven't taken the opportunity to examine the updated edition, you'll want to do so right away:


Thanks for your support of ExcelTips!


ExcelTips (ribbon) for 23 July 2016

Protecting worksheets
Protecting Many Worksheets

Need to protect a lot of worksheets? Rather than protect the sheets individually, you'll appreciate the macros discussed in this tip. They allow you to protect all the worksheets with a single command.

Read this tip »

(Thanks to Michael Avidan (MVP), Steve Aprahamian, Peter Curtis, Richard Leach, Trevor Shuttleworth, Jim Williams, Andrija Vrcan, Colin Delane, Rebecca Wood, Jacques Raubenheimer, Rod Eggink, Ronald Doeleman, Barsha Rana, Brian Poonen, David Teece, Mark English, Miroslav Balchev, and Kyle Fabris for contributing to this tip.)

Changing Months in a Workbook

When you copy a worksheet and then need to make changes to information in that worksheet (such as changing month names), the task can sometimes be daunting. Here are some ideas on how you can make the changes easier.

Read this tip »

Supercharge Your Formatting

Want to change how your data looks based on criteria that you determine? It's easy to do using Excel's powerful conditional formatting features. Picture how you want your data to appear, then use conditional formatting to make it happen. Unleash the power of conditional formatting today.

Linking workbooks
Pulling Access Information into Excel

If you have a lot of data stored in Access databases, you may want to get at that information using Excel. There are a few ways you can go about this task.

Read this tip »

Selecting All Visible Worksheets in a Macro

Do you need your macro to select all the visible worksheets (and just the visible ones)? It's not as easy as it sounds, but this tip uncovers the best way to do it.

Read this tip »


Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Not Enough Resources to Delete Rows and Columns

I have a large Excel worksheet, cuurently 700 columns and 1000 rows. It has formulas in about 600 of those columns, some of which refer to other worksheets held on the server. In total there are about 420,000 formulas in the worksheet. I need to delete some rows and columns, but Excel gives an error message that I do not have enough resources. I have Googled the problem and tried all the suggested solutions but still have the problem. Any thoughts as to how I can remove these columns and rows?
—Harvey Abramson (provide an answer for this Help Wanted question)

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 794  •  Orem, UT  84059  •  801-607-2035