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.
Did you know that you could export data from different SSRS Tablix into different excel sheets of a workbook?
Today I had a requirement from one of my customer to export data from two different tables generated out of SSRS reports into two different...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...