Unable to Save the Excel

[Raghu]

we start refreshing the excel after getting refresh we are not able to save
that excel ,while saving it is saying" A grouped field contains more
items(over 1000) than can be saved in microsoft version 5.0 version worksheet
format "

 

[Jan Karel Pieterse]

Hi Raghu,

we start refreshing the excel after getting refresh we are not able to save
that excel ,while saving it is saying" A grouped field contains more
items(over 1000) than can be saved in microsoft version 5.0 version worksheet
format "

Choose a different file format in the File, Save-as dialog (use the default
"Excel Workbook".

As a side note, your worksheet somewhere contains grouped objects. Is this on
purpose? If not, you might consider removing the objects from the sheet before
saving.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com