Thursday, 25 March 2010

Remove the external links from an Excel File.

Sometimes its so happens that when you open an Excel file, it asks if the External Data needs to be updated or not. But you may not have intentionally given any external links. It’s an irritation then. But How to get rid of it?

Thursday, 18 February 2010

Excel Function :TABLE



Its been a while since I have done some posting. This option in excel is something which I thought would be very useful for many.

Its the TABLE Function in MS Excel. This is especially useful in the following scenarios.