I have a problem porting my tables to MS Excel.
With the same method of porting, some tables can be displayed on excel while others cannot be displayed.
Those that cannot be displayed will return a "Page cannot be displayed" error on the browser. (The excel page is not even called.)
I suspect it might be due to incompatiable version of Excel I used because those tables that originally cannot be displayed on MS Excel 97, can be displayed on MS Excel 2000.
The 2 header lines which I used are as shown below :
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: inline; file=filename.xls");
What could be the problem? Is there anyway to solve this problem without restricting the user to the use of Excel 2000?