Friday, March 02, 2012

Remove the compatibility mode from excel files

As you all know Excel 2007 has lot more features compared to Excel 2003. The extension with which the excel files are saved alos differs based on the version of excel.

For excel 2003 the file is saved as .xls and for Excel 2007 the file is saved as .xlsx

The other day I realised that when I opened a file in Excel 2007 all the features of Excel 2007 are not available for use.

So when I tried to investigate what was happening I found that the file was saved as .xls. So I saved the file as excel 2007 workbook and tried to use all the features.

I was not able to use all the features until I reopened the file in excel 2007.

I thought I would mention this tip here for everyone's benefit.

No comments:

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...