Sat 03 Sep 2016

Tips & Tricks 144 - Enter the Last Save Date and Time

By |Saturday, September 03rd, 2016|Categories: Tips and Tricks|Tags: , , , , , , |0 Comments

1. Open your workbook and ALT+F11
2. Locate your Workbook name in Project Explorer Window
3. Right click on your workbook name > Insert > Module
4. Copy paste the Macro code given
5. Save your file as .xlsm

To get Last Save Date, enter following in a cell
=LastSaveDate()

To get Last Save Time, enter following in a cell
=LastSaveTime()

To get Last Save Date & Time Both, enter following in a cell
=LastSaveDateTime()

Note - You will have to format your result cells appropriately in Date / Time / Timestamp format

< Download the workbook illustrating the same Last Saved Date Time >

 

 

Sat 16 Apr 2016

Article 38 - 10 Features I would like to see in Excel

By |Saturday, April 16th, 2016|Categories: Articles|Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , |0 Comments

Like all of you, I am dependent upon day to day work in Excel. Excel is a software which is like ocean, unlimited in bounds. It has almost all features but it doesn't have few which everybody cherishes. All of us want something or the other. Below is a list of features which I would like Excel to have.

1. Making Volatile Functions Non-volatile on the basis of a Parameter

We all like TODAY(), NOW(), RAND() and RANDBETWEEN() (there are other volatile functions also). They are very useful but suffer a fatal flaw, if something gets recalculated, they always get recalculated also. Hence, if I am using TODAY() to derive today's day and if I open the sheet tomorrow, TODAY() will change tomorrow's date. I wish that all volatile functions should carry a parameter so that they should not recalculated when the sheet is recalculated. For example, we should have something like TODAY(N), NOW(N),RAND(N) and RANDBETWEEN(N) where N
(more…)

Sat 08 Aug 2015

Tips & Tricks 102 - How to Find all Links in an Excel Workbook

By |Saturday, August 08th, 2015|Categories: Tips and Tricks|Tags: , , , , , |0 Comments

Rogue links troubling your workbooks. You have visually inspected them and still you have no clue where to find them, then read on...

Approach 1 - Easiest Approach

Bill Manville offers a free Add-in which finds all links given in your Excel. The utility is a very popular one and it should be must have for any Excel enthusiast. The size is very small. At the time of writing this article, the size was < 100 KB. You can choose whether to install FindLink as an add-in so that it is available whenever you are running Excel or whether to just open it when you want to use it

The details of this utility is given at this link -

http://www.manville.org.uk/software/findlink.htm

You can download the link from following location -

http://www.manville.org.uk/software/findlink.zip

Approach 2 - Manual Approach

If you don't want to use add-in, use below article for finding links (This article doesn't take care of Conditional Formatting links which you will have to do manually. Findlink add-in takes care of this aspect also.)

Find external references (links) in a workbook