speed

kchew · May 1st, 2002, 10:41 AM

I'm wondering why my recent monthly ss are so ery slow, up to 30 seconds, in opening and saving as compared to my Dec and Jan ones, about 3 seconds. They are are both 4 pages, no macros, only sum, %, *, averages. Only differenc I can think of is that the very slow ones have some colored cells.
Any ideas what is wrong?

Thanks
Kwong

Jack in the UK · May 1st, 2002, 01:27 PM

Hi

the first thing i would do is ***** the wight of the SS file size and amount or formatting, formulas that are used.

some thing to look aout for

Flash things, arrays these are killers

if you have long cols of formula say vlookup this can all slow the time of the sheet

May 1st, 2002, 01:27 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi the first thing i would do is ***** the wight of the SS file size and amount or formatting, formulas that are used. some thing to look aout for Flash things, arrays these are killers if you have long cols of formula say vlookup this can all slow the time of the sheet __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 10:41 AM	#1
kchew New Member Join Date: Apr 2002 Posts: 2	I'm wondering why my recent monthly ss are so ery slow, up to 30 seconds, in opening and saving as compared to my Dec and Jan ones, about 3 seconds. They are are both 4 pages, no macros, only sum, %, *, averages. Only differenc I can think of is that the very slow ones have some colored cells. Any ideas what is wrong? Thanks Kwong