Hi Sergio,
It's very hard to diagnose performance problems without being there. What
are the specs on your computer and monitor. RAM, hard disk size and free
space, monitor size and resolution.
1. One factor that slow scrolling down is lots of graphics.
2. Have you tested the same file on other machines?
3. Are other programs open at the same time as Excel.
I'm not sure what you mean by the second question but if you are saying
that
you can only enter 1024 characters in the data validation, List Source box
then instead of entering them in the box, enter them in the spreadsheet
and
reference the range in the Source box.
Cheers,
Shane Deven****re
Microsoft Excel MVP
"Sergio Gi.Ma.G." <sergio@[EMAIL PROTECTED]
> wrote in message
news:C4145C41.BF5%sergio@[EMAIL PROTECTED]
> Hi to all,
> I already explained problems but no one help me to solve problems that I
> have in excel 2004 and my MAC
>
> First (most serious problem): performance!
> I have a SIMPLY file with 6 sheets with basic calculation (like sum) ;
so
> in
> a sheet with 3000 row and 6 colums (very small is not it?) the scroll is
> VERY VERY SLOW. It take 8-10 seconds after my cursor move up or down.
> Forget
> it to select an area to cut, paste, copy or something like that: it
takes
> 15-20 seconds.
> I try to delete application and reistall all office package but the
result
> is the same.
> With Monitor utility I see there is a very indepth use of processor.
Could
> anyone can help me?
>
> SECOND (stupid but............): validate cell
> Validation of cells from a list is limitate to 1024 elements : in a win
> environment there is no limitation. Is a bug? Limtation?
>
> Thank to all for helping me find a soution (specially for the first
> problem!)
> Sergio
>
>
>
>
>
> Environment: excel 11.3.5 MacOS 10.4.11
>
|
