Happy President's Day

This weekend is, in the United States, a holiday weekend. That's because Monday is a federal holiday. Historically, it started as a day to remember the birthday of George Washington, our first president. In the last few decades, however, it has come to be known as President's Day in many states, and is a day to celebrate both Washington and Lincoln's birthdays.

I hope that you find this weekend enjoyable and a time to enjoy some time with your family. (I also hope you enjoy the tips in this week's issue of the newsletter.)

—Allen
     

ExcelTips (ribbon) for 18 February 2017

Protecting workbooks
Removing Protection from a Protected Workbook

Excel provides built-in capabilities to protect your workbook files. If you apply these capabilities, it is possible that at some future date you may want to remove them. This tip focuses on how to remove protection from a protected workbook file when you already know how to open it.

Read this tip »

(Thanks to Guy Goodwin, Steve Aprahamian, Jim Swainson, Alex Blakenburg, Arjun Bijit, Jim Williams, Michal Avidan (MVP), Chris Finn, Alec Whatmough, Shreepad Gandhi, Vanitha Armugam, Shelli Reilly, Inge-Lise Nielsen, Mark Mace, Martin Marcus, and David Ryan for contributing to this tip.)

 
Editing
Relative Worksheet References when Copying

Copy a formula from one place to another and Excel helpfully adjusts the cell references within the formula. That is, it adjusts everything except the names of any worksheets that may be referenced in the formula. Here's how you can get around that lack of change.

Read this tip »

 
Are You Foundering at Filtering?

We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.

 
Data Validation
Stopping Validated Data from being Overwritten

Data Validation is a great tool to make sure that data entered in a cell meets whatever criteria you decide. Its weakness, however, is that people can paste information that overwrites any Data Validation rules. This tip looks at a way you can try to overcome this problem.

Read this tip »

 
Formulas
Extracting a Pattern from within Text

If you have a large amount of data in a worksheet and you want to extract information from the text that meets certain criteria, you have several options you can follow. This tip examines different ways you can extract the desired information.

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.

 
Workbook not Saving

I have an Excel workbook that I've used for years. The file is approximately 18 MB, containing 22 worksheets. The largest worksheet extends to cell HB2000. Recently when I go to save the file, I get a "Document Not Saved" error. I can open and save the document in Libre Office with no problem. What could be causing this problem and how do I fix it?
—Tim Kendal (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 1187  •  Mountain View, WY  82939  •  307-200-0450