total alignment in excel

[jyash]

Hello All,
I am recently facing a weird issue in impromptu (7.3). When i save the report in excel, the totals come in a seperate column (then the corresponding details). I have been using excel a lot but never seen this. I tried the alignment property but it doesnt help.
Any suggestion/solutions will be greatly appreciated.
thanks
yash

 

[drlex]

yash,
Check the settings in Report > Excel. You might want to uncheck some of the 'Include in Excel Worksheet' if you're saving as Excel 2002 and higher' or set the 'Version:' to Excel 2000, although you may lose some of the formatting of the report in this lower-level rendering.

soi la, soi carré

 

[jyash]

thanks a lot drlex.
Switchin to excel 2000 helps. It seems there is a bug in the conversion to excel 2002 or higher.
Is there a way to default to excel 2000 for all the reports.
Yash

 

[drlex]

yash,
I think 7.4 defaults to Excel 2000.

soi la, soi carré