Monthly Archives: March 2019

Linux Delete files older than X

Command Syntax

find /path/to/files* -mtime +5 -exec rm {} \;

Note that there are spaces between rm, {}, and \;

Explanation

  • The first argument is the path to the files. This can be a path, a directory, or a wildcard as in the example above. I would recommend using the full path, and make sure that you run the command without the exec rm to make sure you are getting the right results.
  • The second argument, -mtime, is used to specify the number of days old that the file is. If you enter +5, it will find files older than 5 days.
  • The third argument, -exec, allows you to pass in a command such as rm. The {} \; at the end is required to end the command.

This should work on Ubuntu, Suse, Redhat, or pretty much any version of linux.

ref: https://www.howtogeek.com/howto/ubuntu/delete-files-older-than-x-days-on-linux/

Excel formulas not working properly

I recently had an issue where a user copied an old Excel Spreadsheet to create a new yearly file.

When the new file was opened and data was entered, they found that the formulas were not updating as expected. I tried re-creating the formulas with no luck. When I googled the problem I found the answer.

I’m not sure why this happened, but Automatic updating of formulas was set to Manual. Here are the steps to re-enable Automatic updating of Formulas. This is based on Excel 2010, but I am sure the setting is available on most version of Excel.

Open the spreadsheet with the problem, the select the Formulas tab at the top.

Then choose Automatic from the Calculation Options button on the far right.

Make sure to save the file as you exit.

I found the solution here:  https://www.ablebits.com/office-addins-blog/2016/02/03/excel-formulas-not-working/#excel-formulas-not-updating

There are other problems solved on this webpage too, so you might take a look.