Scroll bar and sorting makes the excel 2007 very slow. Any help

[naveen_grover]

Hi,


I have added scroll bar and sorting (asc,desc) for data of 3000 rows. It makes the system slow. If I used only scroll bar on excel sheet, it does not make any effect however if I add sorting it would make the excel 2007 slow. what should be the remedy.


Thanks,

Naveen

 

[Luke M]

I'm not exactly sure what you are describing. Doesn't XL naturally have scroll bars in it? And sorting is a one time option usually, not something that is constantly active? How did you "add sorting"?

 

[SirJB7]

Hi, naveen_grover!

Consider uploading a sample file.

Perhaps you'd want to read the three green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).

Give a look at the second green sticky post at this forums main page for uploading guidelines.

Regards!